Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot

Re: Last cell?

by cacharbe (Curate)
on Dec 09, 2002 at 17:56 UTC ( #218604=note: print w/replies, xml ) Need Help??

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


Actually, yours is probably faster.


Flex the Geek

Replies are listed 'Best First'.
Re: Re: Last cell?
by Anonymous Monk on Mar 18, 2003 at 18:19 UTC
    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?

      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.


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


      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

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (6)
As of 2023-03-24 11:40 GMT
Find Nodes?
    Voting Booth?
    Which type of climate do you prefer to live in?

    Results (61 votes). Check out past polls.