Adding Data from FormMail to an Excel file

[sberk44]

I am trying to take data submited from a web form and convert that to
an excel spreadsheet. Each new form submitted i would line a new row
or column in that same spreadsheet. Eventually I would like that
spreadsheet emailed everymonth to my client. Any Ideas?

[Sherm Pendley]

sberk44 wrote:

I am trying to take data submited from a web form and convert that to
an excel spreadsheet. Each new form submitted i would line a new row
or column in that same spreadsheet. Eventually I would like that
spreadsheet emailed everymonth to my client. Any Ideas?

What have you tried so far?

In general, I'd save the data to a tab-delimited file on the server, with
tabs between fields and one row per record. Excel can easily import that.

sherm--

--
Cocoa programming in Perl: http://camelbones.sourceforge.net
Hire me! My resume: http://www.dot-app.org

[Sherm Pendley]

sberk44 wrote:

I am trying to take data submited from a web form and convert that to
an excel spreadsheet. Each new form submitted i would line a new row
or column in that same spreadsheet. Eventually I would like that
spreadsheet emailed everymonth to my client. Any Ideas?

By the way, this has *nothing* to do with HTML - you'd get better results
posting to a CGI group.

sherm--

--
Cocoa programming in Perl: http://camelbones.sourceforge.net
Hire me! My resume: http://www.dot-app.org

[sberk44]

Yep...sorry about posting it in HTML site....

well, How would i store that as a csv file or tabdelimited file?

[Sherm Pendley]

sberk44 wrote:

well, How would i store that as a csv file or tabdelimited file?

Briefly: Write a CGI that accepts the incoming form data, formats it
properly, and writes a row to the file. Details, of course, would vary
according to the language it's written in: Perl, Java, PHP, whatever.

In detail: Ask in a CGI group. :-)

sherm--

--
Cocoa programming in Perl: http://camelbones.sourceforge.net
Hire me! My resume: http://www.dot-app.org