The PHPExcel module allows developers to export/import data to/from real Excel files.
The idea behind this module is to have a single module for handling the export or import of Excel files, instead of multiple modules handling specific cases.
The module provides no functionality as-is (the .module file is as good as empty). The
phpexcel.inc file must be included to use the export or import functions in your own module.
In order for this module to work, you must download the PHPExcel library (version 1.7).
This module depends on the Libraries API module.
The PHPExcel library can be extracted in any
libraries folder you want (
sites/*/libraries). You should have
Code downloaded from Github (the new home of the PHPExcel library) will not contain a proper version number in the
changelog.txt file (see for more information). The Libraries API module requires this information, though. If you download the code from Github, open the
changelog.txt file and change the
##VERSION## string to the proper version tag (e.g.
See this comment for more info.
Updating from 2.x to 3.x
phpexcel.api.inc file was still available in 2.x for backward compatibility reasons, but has completely been removed in 3.x. Code must now include
The include path for the PHPExcel library changes. Make sure to move your library files. This may seem odd, but the previous way to store the library was not "right", in that you could not simply extract the downloaded archive to your libraries folder. Now you can.
Sponsored by Connect-i.