On 12/30/05, [EMAIL PROTECTED] <
[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
You're looking for Excel automation documentation, so you need to go to the dark side, and check M$ doc. The source for all their developer documentation is the library at MSDN:
http://msdn.microsoft.com/library
The Excel documentation you're looking for, including the entire Object Model, is under Office Solutions Development, Microsoft Office xx, Office xx, VBA Language Reference, Microsoft Excel Visual Basic Reference. Office 2000 is a little different (look under Microsoft Office 2000 Language Reference instead of VBA Language Reference).
The answer to all your questions is yes. The cell's value (or more accurately, the range's value) is available in several forms, including the Value property (probably what you want) and the Text property, which represents the formatted value of the cell. A range is accessible through the object model whether or not it is visible. You can change this programmatically by setting the Hidden property of an entire row or column. The Border property of a range returns the Border object, and your code can change the border color using the Border's Color or ColorIndex properties.
Happy New Year!
HT
_______________________________________________ ActivePerl mailing list [email protected] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
