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
_______________________________________________
ActivePerl mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

Reply via email to