Use Perl Spreadsheet: parseexcel to parse XML

In Windows, the Excel files required for ActivePerl installation are generally Win32: Ole. For cross-platform platforms, it is best to select another Spreadsheet: parseexcel and spreadsheet: writeexcel. The former is used to read Excel files, and the latter is used to write Excel files.

Spreadsheet: parseexcel can only read Excel documents in 95-2003 format. For Office 2007 excel, install Spreadsheet: XLSX.

(You can directly convert your own Excel file to the 2003 format)

1. Installation

Install in Windows

Ppm> install ole: storage_lite

Ppm> install Spreadsheet: parseexcel

Ppm> install Spreadsheet: writeexcel

Install on Mac

Sudo Perl-mcpan-e "Install 'spreadsheet: parseexcel '"