[Israel.pm] Generating Excel Documents with Pie Charts?

Yuval Yaari yuval at windax.com
Wed May 12 05:44:30 PDT 2004

I didn't even consider using COM (it's just that this article reminded 
me of the subject).
And neither Crossover Office nor OpenOffice...

I was thinking about Spreadsheet::WriteExcel, but it can't generate graphs.
I'll quote the docs:
"Also, here are some of the most requested features that probably won't 
get added:

The format is documented but it would require too much work to 
implement. It would also require too much work to design a useable 
interface to the hundreds of features in an Excel graph. So that's two 
too much works. Nevertheless, I do hope to *try* implement graphs. 
However, it is a long term goal. It won't be available for at least 6 
months, even if you read this in 6 months time."

Anyway, that's the kind of solution I'm hoping for.
It probably doesn't exist, anyway.


Offer Kaye wrote:

>>Can I generate Excel documents with pie charts inside them using Perl on
>>I must admit Excel's pie charts are beautiful...
>>  --Yuval
>I would guess not, since the method outlined in the article relies on COM
>objects. Perhaps using Crossover Office? I doubt it...
>But perhaps there is a similiar way to access the "graph objects" of Open
>Office? If you manage to create graphs this way (and if they look good :)),
>please let us know how you did it :)

More information about the Perl mailing list