Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re: Last cell?

by cacharbe (Curate)
on Dec 09, 2002 at 17:56 UTC ( [id://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

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
Domain Nodelet?
Node Status?
node history
Node Type: note [id://218604]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (5)
As of 2024-04-24 18:35 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found