Click to See Complete Forum and Search --> : Can Perl read Excel files?


lnong
08-20-2003, 04:11 PM
I have a questionaire form in an Excel spreadsheet format (i.e. just a simple 2-column table with questions on the left column and responses on the right column). I want to know if this is possible:

The questionaire form is sent to our customers. When they email back the form with their responses, I want to upload this file to our server via our Perl CGI application. This Perl application will "read" the Excel file and generate an HTML table (just like that same 2-column table describe above) for display.

So I want to know if it's possible for Perl to read an Excel file? Would I need to install some special module.

Please let me know. Thanks.

Charles
08-20-2003, 04:17 PM
With Perl you can do anything but you will need a module for parsing excel. I would suggest Spreadsheet::ParseExcel (http://search.cpan.org/author/KWITKNR/Spreadsheet-ParseExcel-0.2602/ParseExcel.pm) or Spreadsheet::ParseExcel::Simple (http://search.cpan.org/author/TMTM/Spreadsheet-ParseExcel-Simple-1.01/Simple.pm).