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


in reply to Filtering an excel.

Or possibly you could simply dump the spreadsheet in CSV format, make all the required changes using Perl, then let Excel reload the modified CSV file.