PDA

View Full Version : Form to Excel


markpilkinton
07-11-03, 05:09 PM
I need a script that will take the information that is entered into a form and dump it to an Excel spreadsheet. My client wants the form to always add to the same Excel file each time the form has been updated. When the form is submitted, the Excel sheet does not need to be displayed to the person filling out the for, just a simple thank you page. I need the Excel sheet to stay on the sever where I can retrieve when needed. The site is standard HTML on a unix system that has Pearl and PHP, but can be changed to asp or whatever works best.

Thanks
Mark

playtothebeat
07-11-03, 05:17 PM
i dont know if you can add to an actual .xcl file, but i DO know that if you add it to like a .txt or similar file you CAN then open it with excel

simply, add them in the following format:


entry1;entry2;entry3;etc

separate them by semi-colons (;)

if you want, i can write something very simple.. might take me a short while cuz i haven't scripted in a while

but if i were you, i'd find a simple form input script..


this sounds liek a simple job. i've done things VERY similar before