in reply to Win32::OLE formatting Excel Worksheet

There are two utilities that are invaluable when using Win32::OLE.

1. The macro recording facility in Excel/Word/insert the OLE engine of your choice. It is pretty straightforward to translate VBA to Perl.

2. Our own brother jand's OLE browser which is included at least in the ActiveState distribution. This utility can't be praised enough.

As for your question I think it will be an nice exercise to answer it yourself using the two tools above.

Welcome back if all else fails!

  • Comment on Re: Win32::OLE formatting Excel Worksheet

Replies are listed 'Best First'.
Re^2: Win32::OLE formatting Excel Worksheet
by Nkuvu (Priest) on May 10, 2004 at 17:04 UTC
    Another tool I've used extensively is the object browser from within Excel itself. Press Alt-F11 to get to the VB editor, then F2 to get to the browser itself.
[reply]
Re: Re: Win32::OLE formatting Excel Worksheet
by Anonymous Monk on May 11, 2004 at 06:13 UTC
    Thanks all for the information.

    I do not find OLE browser, however, I am getting hands on the use of Excel's Object Browser for those method/property access.
    $Book2->Styles("Normal")->{Font}->{Name} = "Arial";

    Thanks again for example and info.
[reply]

      On my box I can invoke the OLE Browser either via Start-Program-ActiveState-Ole Browser or by clicking the link in the TOC of the html-docs.

      The link is in fact 

      file:///C:/Perl/html/OLE-Browser/Browser.html

      [download]
      but I don't know how that maps to your setup.

[reply]
[d/l]
        Found that browser in my box.

        Thanks.
        Tommy
[reply]

In Section Seekers of Perl Wisdom