[EMAIL PROTECTED] wrote:
Just because it's nearly New Year's, an easy one... Where can I find
documentation on using Excel in Perl through Win32::OLE that's more
Excel-oriented?
The page I found shows an example setting a cell's value, which I get,
but not formatting. I need to set certain cell background and text
colors (for header column & row), cells with *new* info need to get
gold-colored borders, column width & row height, and so on.
Also I need to know if it's possible to read--and then use--a cell's
value. And if it's possible to hide a row AND use that row's content.
This last would be for column aging--the hidden row's cells would
contain dates indicating the last time that column was updated, and
would need to be changed.
Thanks, and Happy New Year!
Deane
It is possible to glean pretty much all of the cell, worksheet, workbook
functions you might want, by recording a short macro in excel.
If you have the PDK then paste the recorded macro into the vbscript
convertor and see what comes out.... strip out any unwanted 'select'
calls and there's often a ready-made sub right there.
HTH - Lynn.
_______________________________________________
ActivePerl mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
