in reply to Win32::OLE & Excel help

If all else fails and you're really desperate, you can also export the Excel file to a .csv file and then search through the CSV in Perl. You can then in parallel update your Excel file. That way, you save a lot of calls and data transfers through the OLE layer, but you add some complexity to your code. I'd use Text::CSV, as that one should even treat embedded newlines in your Excel data well enough.

Replies are listed 'Best First'.
Re^2: Win32::OLE & Excel help
by Bloodnok (Vicar) on Jan 14, 2009 at 12:16 UTC
    Beware, when exporting (using Excel) .XLS to .CSV, that Excel (in its infinite wisdom) can return multiple individual cells for a single cell containing large amounts of data (AFAIR, the limit appeared to be ~ 1kB) - a situation that breaks both Text::CSV & Text::xSV since an unexpectedly higher number of columns appear to be returned from rows containing such cells.

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