in reply to Re: How to modify existing excel file (spreadsheet)
in thread How to modify existing excel file (spreadsheet)

I also have a decent amount of experience using the Spreadsheet modules. I found a lot of those formatting issues can be avoided by formatting a template of the first (in Excel), loading the template (using the Spreadsheet module) and then simply filling the cells using Spreadsheet module.
  • Comment on Re^2: How to modify existing excel file (spreadsheet)

Replies are listed 'Best First'.
Re^3: How to modify existing excel file (spreadsheet)
by Limbic~Region (Chancellor) on Sep 26, 2005 at 17:51 UTC
    ickyb0d,
    It was certainly not that straight forward for me - perhaps you would care to provide an example. For instance, if a group of cells were merged with a yellow background and centered text, I could not simply use Spreadsheet::ParseExcel to read the Excel generated template file and Spreadsheet::WriteExcel to modify the cell's contents without losing formatting.

    I did find ways around the problem but if it is as easy as you say it is, please provide an example.

    Cheers - L~R

[reply]

In Section Seekers of Perl Wisdom