Excel Serialization
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 view.
- Module developers can leverage XLS as a format when using the Serialization API.
Installation
- Download and install PHPOffice/SpreadSheet. The preferred installation method is to use Composer.
- Enable the
xls_serialization
module.
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.