in reply to Converting XLSX to CSV with Perl while maintaining the encoding

Other than the already given advice to use Spreadsheet::ParseXLSX, your code is wrong in that it generated invalid CSV if any of your cells contains " characters.

Consider using Text::CSV_XS and/or Text::CSV for the generation of valid CSV.

Even if your current speadsheeft does not hit this problem, your approach is likely to generate invalid CSV in other cases too.


Enjoy, Have FUN! H.Merijn
  • Comment on Re: Converting XLSX to CSV with Perl while maintaining the encoding
  • Download Code