Re: editing excel files

This might be a lot easier using DBD::Excel as suggested by jasonk. I've used Spreadsheet::WriteExcel and Spreadsheet::ParseExcel but not DBD::Excel. I'd be interested to hear if anyone's used it for updates like this.

Comment on Re: editing excel files

Replies are listed 'Best First'.
Re: Re: editing excel files by CountZero (Bishop) on Feb 13, 2003 at 21:58 UTC
DBD::Excel has its limits though as it expects the spreadsheet to be in a "typical" format with the first row having the field-names. If you have a more involved (or less strict) spreadsheet your outta luck with DBD::Excel. For such relatively simple things I prefer the tab-separated file way as the Spreadsheet-modules are not so simple to use. CountZero "If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law	[reply]

Replies are listed 'Best First'.

Re: Re: editing excel files
by CountZero (Bishop) on Feb 13, 2003 at 21:58 UTC

DBD::Excel has its limits though as it expects the spreadsheet to be in a "typical" format with the first row having the field-names. If you have a more involved (or less strict) spreadsheet your outta luck with DBD::Excel.

For such relatively simple things I prefer the tab-separated file way as the Spreadsheet-modules are not so simple to use.

CountZero

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

[reply]