Re^2: How to modify existing excel file (spreadsheet)

[ickyb0d]

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.

[Limbic~Region]

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.