Re^2: 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.

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 27, 2005 at 14: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. Cheers - L~R	[reply]

Replies are listed 'Best First'.

Re^3: How to modify existing excel file (spreadsheet)
by Limbic~Region (Chancellor) on Sep 27, 2005 at 14:38 UTC

benlaw

experimental support

Spreadsheet::WriteExcel

jmcnamara

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.

Cheers - L~R

[reply]