Deane.Rothenmaier@[...].com 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
ActivePerl@[...].com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs