SpreadSheeet::WriteExcel::Chart

[David Bellamy]

Hello everyone, I'm trying to attach an external chart to a new spreadsheet that i create in Perl on a UNIX system. Every time I try to run my program I get the following error. see attached, can anyone help ?

(in cleanup) Can't locate object method "_prepare_comments" via package "Spreadsheet::WriteExcel::Chart" at /opt/perl_64/lib/site_perl/5.8.7/Spreadsheet/WriteExcel/Workbook.pm line 988.

[Steven E. Protter]

Shalom.

I'm no expert, but I don't think that code can work on Unix. It appears to be code designed to work with Windows based perl.

SEP

[Greg Vaidman · Accepted solution]

We have a script that was written a few years back that uses this Perl module on a HP-UX 11i system, so it's definitely not just for Windows.

This error is actually a known issue with this function introduced in version 2.16 of this module - see http://groups.google.com/group/spreadsheet-writeexcel/browse_thread/thread/a56a6b0e723c8a64

(You might want to subscribe to that forum if you're going to use the module heavily)

A workaround is available here: http://homepage.eircom.net/~jmcnamara/perl/prerel/Spreadsheet-WriteExcel-2.16.1.tar.gz

[H.Merijn Brand (procura]

I'm not a user of the ::Chart module, but I can say that Spreadsheet::ParseExcel and Spreadsheet::WriteExcel are syste-, OS-, and architecture indepenant.
The M$ Excel format is very portable in that sense, and can be parsed and written by perl very easily.

I must admid I was stunned by that too, but it was so much fun to hear McNamara talk about it, and I asked from the audience "Well, of course that won't run on HP-UX!"
He replied "I never tried, but I'm sure it will!"
I the ssh'd to my box in the Netherlands, and tried, and it just worked out of the box. We did a live demo from that box in the audience :)

Enjoy, Have FUN! H.Merijn

[David Bellamy]

Thanks all for your responses. Greg that fixed my problem