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

Hello MOnks, I would like to find out is there any perl module that I can use to write values into an existing excel file. As per what I understand the perl module for Spreadsheet:WriteExcel cannot be used to write to an existing Excel file. echow

Replies are listed 'Best First'.
Re: Perl Module for Excel
by jmcnamara (Monsignor) on Oct 17, 2005 at 11:57 UTC
Re: Perl Module for Excel
by gube (Parson) on Oct 17, 2005 at 12:15 UTC
Re: Perl Module for Excel
by prasadbabu (Prior) on Oct 17, 2005 at 11:56 UTC

    You can make use of Win32::OLE to write in existing excel file.

    Prasad

Re: Perl Module for Excel
by tphyahoo (Vicar) on Oct 17, 2005 at 11:16 UTC
    Spreadsheet::WriteExcel I found the documentation a little confusing, but if I recall correctly there is a lot of good walkthroughs in the samples / test directories.
Re: Perl Module for Excel
by dragonchild (Archbishop) on Oct 17, 2005 at 13:15 UTC
    Depending on how complicated your Excel file is, you could use DBD::Excel, which treats it as a database table.

    My criteria for good software:
    1. Does it work?
    2. Can someone else come in, make a change, and be reasonably certain no bugs were introduced?
Re: Perl Module for Excel
by bart (Canon) on Oct 17, 2005 at 13:12 UTC