Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?

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
Node Status?
node history
Node Type: note [id://218604]
Jar. Jar!...

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (10)
As of 2018-03-23 15:28 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (294 votes). Check out past polls.