Perl Module for Excel

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

Replies are listed 'Best First'.
Re: Perl Module for Excel by jmcnamara (Monsignor) on Oct 17, 2005 at 11:57 UTC
The best way to update an Excel file to to use Excel itself via Windows automation and the Win32::OLE module. See the ActivePerl Winfaq12 for further details. A less complete way is to use Spreadsheet::ParseExcel in combination with with Spreadsheet::WriteExcel (via Spreadsheet::ParseExcel::SaveParser). See the following WriteExcel FAQ. For further information see davies' list of nodes and links related to Index of Spreadsheet FAQs. -- John.	[reply]
Re: Perl Module for Excel by gube (Parson) on Oct 17, 2005 at 12:15 UTC
Hi, Please go through this link with example Reading and writing Excel files with Perl. You get an idea.	[reply]
Re: Perl Module for Excel by prasadbabu (Prior) on Oct 17, 2005 at 11:56 UTC
You can make use of Win32::OLE to write in existing excel file. Prasad	[reply]
Re: Perl Module for Excel by tphyahoo (Vicar) on Oct 17, 2005 at 11:16 UTC
Spreadsheet::WriteExcel I found the documentation a little confusing, but if I recall correctly there is a lot of good walkthroughs in the samples / test directories.	[reply]
Re: Perl Module for Excel by dragonchild (Archbishop) on Oct 17, 2005 at 13:15 UTC
Depending on how complicated your Excel file is, you could use DBD::Excel, which treats it as a database table. My criteria for good software: Does it work? Can someone else come in, make a change, and be reasonably certain no bugs were introduced?	[reply]
Re: Perl Module for Excel by bart (Canon) on Oct 17, 2005 at 13:12 UTC
The module Spreadsheet::ParseExcel::SaveParser combines Spreadsheet::ParseExcel with Spreadsheet::WriteExcel, allegedly.	[reply]