WIn32::OLE Excel Format Style

[twibz]

I am using Perl 5.1.8 and Win32::OLE 0.1101 and having problems with the following:

Trying to read the formatting style of a particular cell:

$format = $Sheet->Cells(1,2)->Style->{'Name'};

where

$Sheet

is a reference to my current worksheet.

The

$format

variable contains "Percent", but when I open Excel directly and look at the cell format, it is "Number", and the cell value is displayed as "209".

Could this be a version problem?
Thanks in advance!

 

[vcherubini]

What version of Excel are you using? XP might not work with an older Perl module.

If you are using XP, you might be out of luck seeing as it was just released several days ago.

Other than that, I don't know what to say. I am not familiar with the module. I assume that you have checked CPAN, but if not, then they might be the place to go. Or,

http://www.perldoc.com,

its a good site that has a lot of documentation on perl.

Sorry I couldn't help more.
Hope this helps.
-Vic vic cherubini
krs-one@cnunited.com

http://www.cnunited.com

====
Knows: Perl, HTML, JavScript, C/C++, PHP, Flash
====