suaveant has asked for the wisdom of the Perl Monks concerning the following question:

A company distributing data via spreadsheet(grrr) or PDF(double grrr) has decided that it'd be a good idea to upgrade to Excel 2007 format. First I had to realize this and switch from Spreadsheet::ParseExcel to Spreadsheet::XLSX. That works pretty good but I am running into character encoding issues... A string which should be "OP«’ES" is coming out as "OP√√ES".

Spreadsheet::XLSX gives the ability to pass a converter to the parser, but I have no idea what conversion I should use. Anyone have any idea?

                - Ant
                - Some of my best work - (1 2 3)