This is an archived low-energy page for bots and other anonmyous visitors.
Please sign up if you are a human and want to interact.
in reply to Re: How to modify existing excel file (spreadsheet)
in thread How to modify existing excel file (spreadsheet)
Limbic~Region
Thx . It seems Spreadsheet::ParseExcel::SaveParser workable in my case. But it cannot copy Graph within the worksheet from template(xls file). Is it possible to do it too?
Thx.
I am learning how to use Win32::Ole, but can it add a 'sheet' at specific page (eg. middle of the 2 sheets) or handle the graph(within worksheet), it seems the tutorial has not talk about that. |
Re^3: How to modify existing excel file (spreadsheet)
by Limbic~Region (Chancellor) on Sep 27, 2005 at 10:38 UTC
|
benlaw,
There is experimental support for charts in Spreadsheet::WriteExcel. The trouble I had was that I needed to hide the data sheet that the chart used so jmcnamara was kind enough to hack it in for me. I needed to use both modules in tandem (along with a bit of source code modification) to achieve everything I needed.
In a nutshell, you create a dummy chart with all the formatting you want and bind it to a datasheet with enough rows/cols to meet your real data, extract the binary representation of that chart to a bin file, and then insert the chart into your new spreadsheet and bind it to a datasheet with the real data. It wasn't a big PITA but it does take a little getting used to.
| [reply] |
|
