Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re: Re: Last cell?

by Anonymous Monk
on Mar 18, 2003 at 18:19 UTC ( #244095=note: print w/ replies, xml ) Need Help??


in reply to Re: Last cell?
in thread Using Win32::OLE and Excel - Tips and Tricks

What is the best way to determine all of the valid fields and subfields for Perl/OLE/Excel information. It is only by studying examples did I learn that Cell->Interior->ColorIndex gets the cell background color, and everything I have learned is by Web examples. Is there a definitive document for all of the possible fields?


Comment on Re: Re: Last cell?
Re: Re: Re: Last cell?
by cacharbe (Curate) on Mar 18, 2003 at 19:44 UTC

    The reference document is the object reference and definition. You can "Browse" it via the tool written by Jan DuBois that I mentioned in the preface of this tutorial.

    <PERLROOT>\html\site\lib\Win32\OLE\Browswer\Browser.html

    Point it at the Microsoft Excel XX.XX objects and browse until your heart's content.

    C-.

    ---
    Flex the Geek

      Thanks, but with win2k, IE5, IE6, ActiveState 5.6, ActiveState 5.8 I just get page with about 5 empty white frames. I will try some other computers tommorow. thank you for the quick reply, tom friedel http://www.readyink.com
        That means that PerlScript is not working correctly on your machine. Did you install ActivePerl via the MSI? If not, then you may need to register it manually with:
        regsvr32 c:\perl\bin\perlse.dll
        or whereever you installed ActivePerl. This registration needs to be done with Administrator privileges. If the OLE browser still doesn't work after registering the PerlScript engine, then you may have problems with your IE security settings (please check the docs). Make sure it is enabled for the local zone, and for the local zone only.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://244095]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (12)
As of 2014-07-28 19:19 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (207 votes), past polls