0

What's the best way to parse a file in SpreadsheetML format with Perl? I've tried Spreadsheet::ParseExcel, but it doesn't recognize the format. Here's the error I get when trying that module:

No Excel data found in file

It looks like CPAN doesn't have a module that can parse it as far as I can see.

What's the easiest way to do it?

Dave
  • 5,436
  • 11
  • 48
  • 74

3 Answers3

2

The Spreadsheet::XLSX or SimpleXlsx Perl modules can be used to read the XLSX format.

jmcnamara
  • 38,196
  • 6
  • 90
  • 108
2

It's XML, use XML::Twig to process the file or XML::XPath to grab values.

Axeman
  • 29,660
  • 2
  • 47
  • 102
2

Searching CPAN for 'spreadsheet excel xml' results in Spreadsheet::ParseExcel, which mentions in the description:

The module cannot read files in the Excel 2007 Open XML XLSX format. See the Spreadsheet::XLSX module instead.

Worth to try...

pwes
  • 2,040
  • 21
  • 30