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 4.0.x version uses the composer to automatically manage dependencies. You just need to use the composer to download this module, it will automatically handle the dependence.
It provides a very simple way for developers to use it.

$phpexcel = \Drupal::service('phpexcel');
$filepath = 'modules/contrib/phpexcel/tests/src/Functional/data/phpexcel.test.multi_sheet.xlsx';
$result = $phpexcel->import($filepath);

The 8.x-3.x and previous versions.
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.

Dependencies

The 4.0.x version uses the composer to automatically manage dependencies.

The 8.x-3.x and previous versions.
In order for this module to work, you must download the PHPExcel library (version 1.7.8 or higher).
This module depends on the Libraries API module.

Installation

Install the module version 4.0.x as with every other module. No additional handling of dependent libraries is required

The PHPExcel library can be extracted in any libraries folder you want (sites/*/libraries). You should have sites/*/libraries/PHPExcel/Classes/PHPExcel.php (make sure you get the changelog.txt file as well; Libraries API needs it).

Updating from 2.x to 3.x

The 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 phpexcel.inc.
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.

RTBC issues for PHPExcel

Filters