This Module provides an XLS file parser for the Feeds module. XLS files are the standard used by Microsoft Office Excel, and can be created by a number of other Spreadsheet applications.

Features

It works in a similar way to the Feeds CSV parser, providing exactly the same options. The module should be able to read the following file formats (as supported by PHPExcel):

  • Excel 2007 (spreadsheetML)
  • BIFF5 (Excel 5.0 / Excel 95), BIFF8 (Excel 97 and higher)
  • PHPExcel Serialized Spreadsheet
  • Excel 2003 XML format
  • Open Office Calc (.ods)
  • Gnumeric
  • Symbolic Link (SYLK)
  • CSV (Comma Separated Values)

The module also dynamically creates template files for each import. These have not been extensively tested, although they do provide the following features:

  • If a field is required, the column in the template file will be required.
  • If the field is an "Options list", the field will provide a drop down box to the user.
  • As with the "Options list", if the field is a taxonomy, all values in the taxonomy will be embeded in an additional worksheet, with values in the cell restricted to values in the additional worksheet.

Requirements

  • The PHPExcel library should be installed, either in a location that the Libraries module can find (if the Libraries module is installed), or in the feeds_xls folder. The folder should be renamed "PHPExcel". If you're having difficulty with this, try the instructions under the Issues queue, or as a last resort, post a help request.

Project Information

Downloads