Thanks for the suggestion. But I did not find the relative subroutine in Win32::OLE to append the excel file worksheet.
| [reply] |
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] |