konarsourav/xls_serialization

Provides Excel as a serialization format.

dev-main 2020-12-31 13:40 UTC

Requires

• phpoffice/phpspreadsheet: dev-master

GPL-2.0+

README

Excel Serialization

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/SpreadSheet. The preferred installation method is to use Composer.
• Enable the xls_serialization module.

Creating an XLS view

1. Create a new view
2. Add an Excel Export display for more formatting options. Otherwise add a REST Export view.
3. Check either 'xlsx' or 'xls' for the accepted request formats under Format -> Excel export -> Settings.
4. Add desired fields to the view.
5. Add a path, and optionally, a filename pattern.