in reply to Modifying an existing Excel file

toncelli,
I recently had a similar task and needed to rely on Spreadsheet::ParseExcel and Spreadsheet::WriteExcel as the work was being performed on a *nix platform. I found Re: open workbook-WriteExcel helpful but I had to break encapsulation several times to preserve formatting when modifying existing cells. Let me know if you go this route and have specific problems.

Cheers - L~R

Replies are listed 'Best First'.
Re^2: Modifying an existing Excel file
by toncelli (Initiate) on May 05, 2005 at 14:46 UTC
    Thanks, I tried the with the sample and as mentioned in the documentation if you have graphs or macros in the same file they will be lost. If it's not possible to modify a the file if it includes graphs, is there a way to recreate the graphs? I can use Spreadsheet::WriteExcel to recreate all the data.
[reply]
      toncelli,
      Spreadsheet::WriteExcel has experimental support for graphs and I have been able to get them to work. It takes a little practice so see the documentation and examples.

      Cheers - L~R

[reply]

In Section Seekers of Perl Wisdom