Re: CGI form to Excel file

Th easiest thing you can do is produce a CSV file which Excel can load. Text::CSV_XS is a great tool for the job. Slightly harder is to create a real Excel file using Spreadsheet::WriteExcel. That will let you create formulas, fill in multiple sheets, add formatting, etc.

If you're also wondering about how to get started writing the CGI itself, I suggest you pick up a copy of O'Reilly's CGI Progamming with Perl book. It's a good introduction to the wide range of tools available.

-sam

Comment on Re: CGI form to Excel file

Replies are listed 'Best First'.
Re^2: CGI form to Excel file by jamesmkennedy (Initiate) on Jun 14, 2006 at 18:56 UTC
Thanks for the quick reply. I'll take a look at Spreadsheet:WriteExcel. I've created text files before in Perl and separated them by delimiters like semi-colons, colons, etc. (I'm assuming Text::CSV XS is for something like this?), and I've also separately imported text files into Excel based on delimiters many times. Thanks, James Kennedy	[reply]
Re^3: CGI form to Excel file by samtregar (Abbot) on Jun 14, 2006 at 20:04 UTC
Text::CSV_XS is a module to create and parse CSV files very quickly, without skipping any of the hard stuff. By hard-stuff I mean proper quoting, escaping, dealing with cross-platform line-breaks (although sadly, it doesn't deal well with Mac line-breaks), etc. -sam	[reply]