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 da
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 wil
> 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
003 7:31 AM
To: '[EMAIL PROTECTED]'
Subject: Excel, hyperlinks and empty rows.
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
