Re: Re: Excel Spreadsheet Data Set

[jmcnamara]

The reverse direction is even more cumbersome: putting several CSV files into a workbook as separate worksheets.

The Spreadsheet::WriteExcel module can create a multiple worksheet Excel file on Unix. The standard distribution comes with an example program called csv2xls.pl which will convert CSV to an Excel file. There is also an example here.

Anyone know of a portable library (preferably with a Perl module interface) for directly manipulating Excel workbook files? It would have to work on UNIX (Solaris, and maybe Linux).

Takinori Kawai's DBD::Excel module provides a DBI wrapper around Spreadsheet::WriteExcel and Spreadsheet::ParseExcel on all platforms. In addition Spreadsheet::ParseExcel, by the same author, contains a module called Spreadsheet::ParseExcel::SaveParser which uses WriteExcel and ParseExcel to provide a round-trip access to Excel files.

None of these solutions are 100% effective but they may serve your needs.

John.
--