Re^2: Append row into existing excel file

Thanks for the suggestion. But I did not find the relative subroutine in Win32::OLE to append the excel file worksheet.

Comment on Re^2: Append row into existing excel file

Replies are listed 'Best First'.
Re^3: Append row into existing excel file by Bloodnok (Vicar) on Apr 04, 2009 at 15:39 UTC
AFAIR, there isn't a specific routine to do that since, given the worksheet is (ostensibly) infinite [sic], how on earth would the routine know where the end is ... and thus when to stop. It has to be home grown and typically (well, mostly :-) depends on searching down the worksheet to the first row that meets your criteria for an empty row e.g. the first row for which some unique identifier is not set, and appending the new data thereafter. A user level that continues to overstate my experience :-))	[reply]

Replies are listed 'Best First'.

Re^3: Append row into existing excel file
by Bloodnok (Vicar) on Apr 04, 2009 at 15:39 UTC

It has to be home grown and typically (well, mostly :-) depends on searching down the worksheet to the first row that meets your criteria for an empty row e.g. the first row for which some unique identifier is not set, and appending the new data thereafter.

A user level that continues to overstate my experience :-))

[reply]