Re: Re: Using Win32:OLE on Excel

Thanks for your prompt answer, that did the trick. I also read that node you pointed out. Out of curiosity, how would one, given a set range of rows (say 7 - 21) get the Range object. The msdn docs gave a discrete set of rows but not much info on a contiguous range of rows. Thanks again.. Geoff

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

Replies are listed 'Best First'.
Re: Re: Re: Using Win32:OLE on Excel by cacharbe (Curate) on Jul 01, 2002 at 19:49 UTC
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	[reply] [d/l] [select]