in reply to Perl module to write to an existing excel file in linux

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
  • Comment on Re: Perl module to write to an existing excel file in linux