开发者

Parsing SpreadsheetML Using Perl

开发者 https://www.devze.com 2023-01-12 20:43 出处:网络
What\'s the best way to parse a file in Sprea开发者_StackOverflow中文版dsheetML format with Perl?I\'ve tried Spreadsheet::ParseExcel, but it doesn\'t recognize the format.Here\'s the error I get when

What's the best way to parse a file in Sprea开发者_StackOverflow中文版dsheetML 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?


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...


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


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

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号