http://www.perlmonks.org?node_id=218604


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