how to use spreadsheet

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: how to use spreadsheet by planetscape (Chancellor) on Feb 13, 2006 at 09:41 UTC
IMHO, Index of Spreadsheet FAQs lists pretty much everything you could ever want or need - modules, FAQS - with regard to working with Excel. HTH, planetscape	[reply]
Re: how to use spreadsheet by davido (Cardinal) on Feb 13, 2006 at 07:09 UTC
Install Active Perl From the command prompt, type 'ppm' from the `ppm>` prompt, type 'search excel' Install any of the modules you see on the list by typing 'install n' (where 'n' is the number listed next to the module you wish to install. You can also install a module "by name" instead of by search number. This is documented in the PPM documentation, included with Active State Perl. Dave	[reply]
Re: how to use spreadsheet by brian_d_foy (Abbot) on Feb 13, 2006 at 08:06 UTC
You can check out the Spreadsheet::WriteExcel, Spreadsheet::ReadExcel, or many of the other Excel modules you can find on CPAN Search. Good luck! :) -- brian d foy <brian@stonehenge.com> Subscribe to The Perl Review	[reply]
Re: how to use spreadsheet by davidrw (Prior) on Feb 13, 2006 at 13:41 UTC
using Win32::OLE is another common method for dealing with excel files -- it will let you control MS Excel, so you can pretty much do anything that excel can ... Super Search or google for "Win32::OLE excel" ... planetscape beat me to the uber-list of spreadsheet links -- be sure to take a look at that node..	[reply]
Re: how to use spreadsheet by hesco (Deacon) on Feb 13, 2006 at 08:38 UTC
In 2004, I had a client who insisted on excel spreadsheets for all the data reports. She didn't want to hear or learn about the importation of csv data. After a few days of handling the import myself in OpenOffice and exporting an .xls to email across the continent, I finally found Spreadsheet::WriteExcel and Text::CSV_XS, which in a day of study and coding permitted me to handle these nightly reports from an unattended cron job. Good thing, too, as I was getting little enough sleep as it was on that job. -- Hugh	[reply]