in reply to Last cell?
in thread Using Win32::OLE and Excel - Tips and Tricks
Upon further investigation, I have found that this is not reliable if the columnar data is not of equal row size. It returns the last row of the right most column, which is incorrect in some cases.
The methods I used in the examples return the last row (over all) and the last column (over all) vs finding the location of the last cell in the last column
So, if the data on the worksheet is symmetric, your function works faster, however yours would not be reliable to, say, put edges around all the cells in a data set that has columns of different row sizes
C-.
---
Flex the Geek
|
---|
Replies are listed 'Best First'. | |
---|---|
last row/column
by Foggy Bottoms (Monk) on Jun 18, 2003 at 09:35 UTC | |
last row/column
by Foggy Bottoms (Monk) on Jun 18, 2003 at 09:37 UTC | |
by cacharbe (Curate) on Jun 18, 2003 at 13:35 UTC | |
by Foggy Bottoms (Monk) on Jun 18, 2003 at 13:44 UTC | |
Re: Re: Last cell?
by Nkuvu (Priest) on Mar 04, 2003 at 23:01 UTC |
In Section
Tutorials