Excel Serialization
Categories
Component ID
2786573
Component name
Excel Serialization
Component type
module
Maintenance status
Development status
Component security advisory coverage
covered
Downloads
9835
Component created
Component changed
Component body
This module provides an Excel encoder for the Drupal 8 Serialization API. This
enables the XLS format to be used for data output (and potentially input,
eventually). For example:
- Drupal 8's REST module can return data in XLS format.
- Views can output XLS data via a 'REST Export' view, or a
Data Export view. - Module developers can leverage XLS as a format when using the Serialization
API.
Installation
- Download and install PHPOffice/PHPExcel. The preferred installation method is to use Composer.
- Enable the
xls_serializationmodule.
Creating an XLS view
- Create a new view
- Add a Data Export display (this assumes the use of the Views Data Export) module. Otherwise add a REST Export view.
- Check only 'xls' for the accepted request formats under
Format > Data export > Settings. - Add desired fields to the view.
- Add a path, and optionally, a filename pattern.
