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.
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.
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.
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.
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.
Supporting organizations:
Development
Project information
- Project categories: Import and export
- Ecosystem: Excel Serialization
16 sites report using this module- Created by mably on , updated
Stable releases for this project are covered by the security advisory policy.
Look for the shield icon below.
