How to create Open Document Format spreadsheet with charts using Perl?
Asked
Active
Viewed 688 times
2 Answers
1
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
- 29,660
- 2
- 47
- 102
-
So far, I have tried only `OpenOffice::OODoc`. I'll give `ODF::lpOD` a try. – el.pescado - нет войне Aug 13 '10 at 14:52
-
Update: first paragraph of linked section states: "They shouldn't appear in text or spreadsheet documents", unfortunately. – el.pescado - нет войне Aug 13 '10 at 14:53
-
@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 Aug 13 '10 at 15:09
1
I use Spreadsheet::WriteExcel to make Excel spreadsheets with charts and I open the documents just fine in Open Office, on Linux or Windows.
You can also now use Excel::Writer::XLSX
runrig
- 6,486
- 2
- 27
- 44