Re^3: XLSX to CSV with high ASCII characters

Just glancing at xls2csv, I see that it uses Spreadsheet::ParseExcel. Your script uses Spreadsheet::Read, which uses Spreadsheet::ParseXLSX, which is a front end for Spreadsheet::ParseExcel. Have you tried using ParseExcel directly without all the middlemen, like xls2csv does?

Comment on Re^3: XLSX to CSV with high ASCII characters

Replies are listed 'Best First'.
Re^4: XLSX to CSV with high ASCII characters by apu (Sexton) on Aug 27, 2017 at 22:18 UTC
I have not tried the other modules but I'm willing to give it a try. For what it's worth, though, the xls2csv I have does use Spreadsheet::Read. I believe it was installed when Spreadsheet::Read was installed via CPAN. (It uses Text::CSV_XS instead of Text::CSV and \r\n instead of \n but I did try those already with no change in my output.) `# xls2csv: Convert Microsoft Excel spreadsheet to CSV # (m)'17 [07-06-2017] Copyright H.M.Brand 2008-2017 [...] our $VERSION = "3.3"; [...] use Text::CSV_XS; use Spreadsheet::Read qw( ReadData row );` [download]	[reply] [d/l]
Re^5: XLSX to CSV with high ASCII characters by Anonymous Monk on Aug 27, 2017 at 23:38 UTC
Ok, so you're running the example script that comes with Spreadsheet::Read, not xls2csv. Now, are you using the --all option? Without that option, xls2csv is simply a front end for xlscat.	[reply]