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?
- Some of my
best work - (1 2 3)