views:

49

answers:

2

How to create Open Document Format spreadsheet with charts using Perl?

A: 

Have you looked at ODF::lpOD? The page for ODF::lpOD::StructuredContainer says it gives access to "draw pages"

This manual page is related to the sections, item lists, draw pages, frames, and drawing shapes.

If you're not talking about the generalized format, and your target is specifically OpenOffice.org you want to get right down to the bottom of it you could use OpenOffice::UNO.

If nothing else, because charts exist in the XML, you can probably manipulate the XML in the document.

Axeman
So far, I have tried only `OpenOffice::OODoc`. I'll give `ODF::lpOD` a try.
el.pescado
Update: first paragraph of linked section states: "They shouldn't appear in text or spreadsheet documents", unfortunately.
el.pescado
@el.pescado, Yeah it looks like Charts are a TODO for the main project as well: http://docs.lpod-project.org/level1-graphic-content.html#charts-todo
Axeman
A: 

I use Spreadsheet::WriteExcel to make Excel spreadsheets with charts and I open the documents just fine in Open Office, on Linux or Windows.

runrig