Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

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

TMTOWTDI

Actually, yours is probably faster.

C-.

---
Flex the Geek


Comment on Re: Last cell?
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.

      <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

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (4)
As of 2015-08-01 02:43 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (285 votes), past polls