Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Re: Re: Re: Using Win32:OLE on Excel

by cacharbe (Curate)
on Jul 01, 2002 at 19:49 UTC ( [id://178661]=note: print w/replies, xml ) Need Help??


in reply to Re: Re: Using Win32:OLE on Excel
in thread Using Win32:OLE on Excel

That depends. *grin*

If you know the Columns involved, then: 

my $Range = $Sheet->Range($col.$startrow.":".$col.$endrow);

[download]

or if you just want an entire column:
my $Range = $Sheet->Columns($colletter);

[download]
or if you just want an entire row:
my $Range = $Sheet->Rows($rownumber);

[download]

There are, of course, a million ways to do it.

C-.

---
Flex the Geek

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://178661]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others avoiding work at the Monastery: (5)
As of 2024-04-24 07:22 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found