Hi Richard;
This works for me to return the last populated row --
$worksheet_rows = $worksheet-UsedRange-rows-count;
Don't know about the hyperlink.
HTH,
Glen
-Original Message-
From: Beckett Richard-qswi266 [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 10, 2003 7:31 AM
To: '[EMAIL
On Thu, 10 Jul 2003, Beckett Richard-qswi266 wrote:
Guys,
Struggling to find the following information...
I'm using Win32:OLE to insert text into a spreadsheet.
Currently I have to start a new spreadsheet every time. How can I detect the
first empty row, so that I can append new data to
This works for me to return the last populated row --
$worksheet_rows = $worksheet-UsedRange-rows-count;
Hmmm...
Been playing with this. If the sheet has data on it, then it does return the
number of the last populated row.
If the sheet is empty, it returns 1, which means that I insert my
Beckett Richard wrote:
I did get this suggested:
my $LastRow = $sheet-UsedRange-Find({What=*,
SearchDirection='xlPrevious,
SearchOrder=xlByRows})-{Row};
but I get bareword errors on xlPrevious and xlByRows when I try
to use it, and I can't work out a syntax that will work.
Try