xls_serialization_extras

Sandbox for the Excel Serialization module.

This sandbox is used to experiment with new features for the Excel Serialization module. The goal is to migrate all successfully user-validated features back to the original module.

Important: To benefit from the new features of the module, you must use the new Fields Excel row handling plugin, it should be selected by default.

This module requires the 2.1+ version of the Excel Serialization module.

Warning: This module is highly experimental and relies on some internal Drupal behaviors. Use it with caution.

New "extras" features

Support for cell styling using field formatters

Select the Excel field formatter (when available) to set text styles (bold, italic, underline, color), column alignment (left, right, center), or to collapse the column.

If the Link to entity option is enabled, an Excel hyperlink with an absolute URL targeting the corresponding entity will be created for the cell.

• Solves #3060027: Allow styling table cells using field formatters from core

Support for DateTime and Timestamp patterns

Select the Excel field formatter to generate real date cells in Excel, formatted according to the chosen Drupal date format.

Support for long numeric values

Select the Excel field formatter to force long numeric values to display as text, avoiding Excel’s default scientific notation formatting.

• Solves #3056686: Large numbers shown with scientific notation

Support for link field values

Use the Excel field formatter to render link fields as clickable hyperlinks in Excel. By default, only the link text is displayed.

Support for styled image insertion

Select the Excel field formatter to insert the corresponding styled image into your Excel spreadsheet.

• Solves #3382673: Is there a way to export images to Excel?

Support for formulas with tokens

Add a new Excel formula field to your Drupal view and use tokens to reference other fields or the current row number ({{ row }}) in your custom formula.

• Solves #3489727: Fields with wanted Excel formulas don't work anymore

A filter mechanism has been added to the token processing code allowing to escape double-quotes in field tokens among others.

Here is an example of such filtered token: {{ title|upper|escape }}.

New sheet alter and row processor hooks

Remember to select the new Excel export (Extras) view style to activate the row processor hook.

Check the xls_serialization_extras.api.php file for examples.

• Solves #3339290: Spreadsheet alter
• And #3370352: Add ability to alter rows in xls export