Newer
Older
This module provides an Excel encoder for the Drupal Serialization API. This
enables the XLS format to be used for data output (and potentially input,
eventually). For example:
* Drupal's REST module can return data in XLS format.
* Views can output XLS data via a 'REST Export' view, or a
[Data Export](https://www.drupal.org/project/views_data_export) view.
* Module developers can leverage XLS as a format when using the Serialization
API.
#### Installation
* Download and install
[PHPOffice/SpreadSheet](https://github.com/PHPOffice/PhpSpreadsheet). The preferred
installation method is to
[use Composer](https://www.drupal.org/node/2404989).
* Enable the `xls_serialization` module.
#### Creating an XLS view
2. Add a Data Export display (this assumes the use of the Views Data Export)
module. Otherwise add a REST Export view.
3. Check only 'xls' for the accepted request formats under Format >
Data export >Settings.
5. Add a path, and optionally, a filename pattern.