Skip to content
Snippets Groups Projects
README.md 1.06 KiB
Newer Older
# 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](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

Thom Heemstra's avatar
Thom Heemstra committed
1. Create a new 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.
Thom Heemstra's avatar
Thom Heemstra committed
4. Add desired fields to the view.
5. Add a path, and optionally, a filename pattern.