P is for Practical | |
PerlMonks |
Re: Perl module to write to an existing excel file in linuxby marto (Cardinal) |
on Jul 13, 2007 at 08:31 UTC ( [id://626399]=note: print w/replies, xml ) | Need Help?? |
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
In Section
Seekers of Perl Wisdom
|
|