http://www.perlmonks.org?node_id=997450


in reply to Re^2: How to implement pattern nmatching and then inserting data in a XLS file
in thread How to implement pattern nmatching and then inserting data in a XLS file

Yes, I agree. That's just one of solutions and I check Excel modules on CPAN, but until now have found only modules like Excel::Writer for creation of Excel worksheets and without simple 'find and replace' function.

I guess the best approach for you would be to use Win32::OLE module, example with using 'find' function is presented here Re: Win32::OLE Excel search and replace commas (adapting it to find & replace should not be hard).

  • Comment on Re^3: How to implement pattern nmatching and then inserting data in a XLS file