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.
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.