Perl module to write to an existing excel file in linux

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

Hi , Spreadsheet::WriteExcel cannot write to an existing Excel file.
I need some way for writing to an existing Excel file.
Please let me know if any module or the way available for LINUX.
Thanks,
Nagaraju

Comment on Perl module to write to an existing excel file in linux

Replies are listed 'Best First'.
Re: Perl module to write to an existing excel file in linux by marto (Cardinal) on Jul 13, 2007 at 08:31 UTC
Hi nagaraju, You are correct, Spreadsheet::WriteExcel can not write to an existing Excel file. See this article from IBM DeveloperWorks which demonstrates how to achieve this using Spreadsheet::ParseExcel and Spreadsheet::WriteExcel. An alternative may be to use DBI with DBD::Excel (which is based on the modules I previously mentioned). I have never used DBD::Excel which CPAN shows as being in Alpha state. Hope this helps Update: Added '(which is based on the modules I previously mentioned)' Martin	[reply]

Replies are listed 'Best First'.

Re: Perl module to write to an existing excel file in linux
by marto (Cardinal) on Jul 13, 2007 at 08:31 UTC

nagaraju

Spreadsheet::WriteExcel

this article

IBM DeveloperWorks

Spreadsheet::ParseExcel

Spreadsheet::WriteExcel

DBI

DBD::Excel

CPAN

Alpha

Update:

[reply]