Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
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?
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 cooling their heels in the Monastery: (3)
As of 2014-09-20 02:01 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (151 votes), past polls