Thread

Posted on Mon Apr 23 14:02:28 2007 by masterjoh
Parsing Charts
Hi! Im currently working on print-reports based on Ms-Excel. In this case i created an Excel-document, which contains the structure and some context-files where to receive the data from. Im reading the data by using the module Spreadsheet::ParseExcel, then creating a new file with Spreadsheet::WriteExcel, filling in the data from existing excel-document and then adding the data i selected from the database.

At first i would like to acknowledge, that there are some differences in the declaration of format-ojects between Parse- and WriteExcel for example
"font->{Height}"
in Parse- is
"font->{Size}"
in Write-Excel. I used the setter-functions of WriteExcel to make the mapping.

Everything is working fine, even reading and writing formulas. The only problem i have is that i could not find out how to read and write charts. Does anyone have a clue how to solve this?

Greetings, Joh
Direct Responses: 8257 | Write a response
Posted on Thu Jul 10 01:18:55 2008 by pfudd in response to 4969
Re: Parsing Charts
I've tried writing charts, but the results look bad in Excel. There is no support for reading charts or their settings, but if you know which cells have the chart data, you can read them.
Write a response