Win32::OLE Excel and cell formatting 1

[JaySang]

I'm populating an excel file from a perl script using Win32::OLE, but when I push a number with a decimal point excel auto formats it takes off the .0.

How can I set the cell formatting to allow for one decimal point ?

Thanks

 

[dmazzini]

Try it:

$Sheet->Columns("A:A")->{NumberFormat} = "###.#";

dmazzini
GSM System and Telecomm Consultant

 

[JaySang]

Works like a charm, thanks!!

 

[MillerH]

dmazzini,

Is there place that documents the functionality of Win32::OLE access for Excel. I've learned that it might be in included in the documentation for Visual Basic, but if that's the case, is there an online version of that documentation?

This is the one module that is asked the most about for which I'm unaware of where the documentation lies. So any insight would be most helpful.

- Miller

 

[dmazzini]

I have not found any web page showing VBA documentation.

However this VBA help is saved in your windows PC in the Office directory. So, you could use it without open VBA Editor.

Check this link:

http://support.microsoft.com/kb/222101

There, you will see a table showing the Help Files for each Office application.

VBA for Excel help files:

VbaXl8.hlp Application Version 97 (or 8.0)
Vbaxl9.chm Version 2000 (or 9.0) 
Vbaxl10.chm Version 2002 (or 10)
VBAXL10.chm Version 2003 (or 11)

ActiveState's Perl Dev Kit comes with an application called
VBScript Converter. It is a graphical tool that translates VBScript code to its functional equivalent in Perl. The problem is that it is not free.

http://www.activestate.com/Products/perl_dev_kit/pricing.plex

dmazzini
GSM System and Telecomm Consultant