Re: EXCEL TO HTML Conversion w/Perl

Depending on how your Excel spreadsheets are formated, you could try to get the data out of them through DBI and DBD:Excel.

If the spreadsheets cannot be used as a database, you will have to use Spreadsheet::ParseExcel which offers a rather low level of access to the spreadsheet. There are some more sophisticated wrappers around this module, so have alook at CPAN!

CountZero

"If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law

Comment on Re: EXCEL TO HTML Conversion w/Perl

Replies are listed 'Best First'.
Re^2: EXCEL TO HTML Conversion w/Perl by drewbie (Chaplain) on Jun 08, 2004 at 02:26 UTC
I just did a search and other than DBD::Excel (which you mentioned), I only found Spreadsheet::ParseExcel::Simple which is very high level indeed and hasn't been updated since Dec 2002 so I don't know if it still works. Are there other modules you commonly use? If so, I'd love to know since I hate dealing with Excel at such a low level.	[reply]
Re^3: EXCEL TO HTML Conversion w/Perl by CountZero (Bishop) on Jun 08, 2004 at 06:26 UTC
I try to do most of my Excel-parsing through DBI or not at all. For one-off jobs I sometimes just dump the spreadsheet to a CSV-file and work with that. I find spreadsheets too much "free format" and contain too much "eye candy" for PHB's to work with. Most of the time I go the other way around: from a database to a spreadsheet (to give to my database-challenged colleagues). That being said, I should just give Spreadsheet:ParseExcel::Simple or its underlying Spreadsheet:ParseExcel a whirl. Maybe these modules are fully developped and did not need updating since 2002! (yeah yeah and maybe the moon is made out of green cheese) CountZero "If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law	[reply]