Drupal is a registered trademark of Dries Buytaert
Protected Pages 3.0.0 Major update available for module protected_pages (3.0.0). Commerce Core 3.3.8 Minor update available for module commerce (3.3.8). Search API HTML Element Filter 1.0.7 Minor update available for module search_api_html_element_filter (1.0.7). Layout Builder Reorder 2.0.1 Minor update available for module layout_builder_reorder (2.0.1). Ban 1.1.0 Minor update available for module ban (1.1.0). Field Formatter Range 2.0.0 Major update available for module field_formatter_range (2.0.0). Field Formatter Range 8.x-1.8 Minor update available for module field_formatter_range (8.x-1.8). UI Patterns (SDC in Drupal UI) 2.0.18 Minor update available for module ui_patterns (2.0.18). Search API Solr 4.3.11 Module search_api_solr updated after 14 months of inactivity (4.3.11). Provus Mega Menu Module provus_mega_menu crossed 1,000 active installs.

This module enables Views Data Export to create XLSX files using the maintained PhpSpreadsheet library, with options for column color selection and custom header text. It also supports exporting images directly within the export.

This module extends Views Data Export module to allow XLSX files export.
Clone from data export phpexcel to use a library that is
a) maintained and
b) compatible with PHP 7.2.
add option select color for each column

Requirements
------------
1. Views Data Export
2. PhpSpreadsheet
3. Libraries or Composer Manager

Installation if Using Libraries Module
--------------------------------------
1. Download the PhpSpreadsheet library and extract it inside your site's libraries folder:
- sites/all/libraries/PhpSpreadsheet
2. Run "composer install" in folder libraries/PhpSpreadsheet to install all the dependencies
3. Enable the module.

Installation if Using Composer Manager
--------------------------------------
1. Ensure that composer_manager is enabled.
2. Use drush to install the module: `drush en views_data_export_phpspreadsheet`
3. Check the site's Status Report for the "PhpSpreadsheet library" entry. With
composer_manager enabled, drush should have automatically installed the
necessary libraries. If not, run:
- `drush composer-json-rebuild`
- `drush composer-manager update phpoffice\phpspreadsheet`

Switch from Libraries to Composer Manager
-----------------------------------------
1. Enable composer_manager.
2. Delete the existing library files at sites/all/libraries/PhpSpreadsheet.
3. Rebuild the master composer.json file: `drush composer-json-rebuild`
4. Update/install: `drush composer-manager update phpoffice/phpspreadsheet`
5. Check the site's Status Report for the "PhpSpreadsheet library" entry.

Switching from views_data_export_phpexcel
-----------------------------------------------
This module is intended to run as a replacement for views_data_export_phpexcel
to the greatest extent possible. Ideally, you will not need to rebuild your
views to use it. To make this possible, however, some function names have been
duplicated, which makes the modules incompatible.

1. Disable views_data_export_phpexcel. If you have features that depend on it,
this will fail until you remove the dependency.
- Search for "views_data_export_phpexcel" in your feature .info files.
- If there is a dependency, remove or comment that line, and add
'features_exclude[dependencies][views_data_export_phpexcel] = views_data_export_phpexcel'
at the bottom.
- `drush cc all`
- Try disabling the module again.
2. Install and enable this module.

Usage
-----
Follow the instructions from README.txt of the Views Data Export module.

for drupal 8 9

- Support format
- Open Document Format/OASIS (.ods)
- Excel 2007 and above (.xlsx)
- Excel 97 and above (.xls)
- SpreadsheetML (.xml) (XML is ready support by Views data export but not for excel)
you can insert custom text for header
New feature for field image it will add image directly (just 1 image)

suport reader for service
- Microsoft Symbolic Link (.sylk)
- CSV (ready support by Views data export)
- Gnumeric (can export but i can't test yet)

Do you like this module? Show your appreciation by buying me ☕.

Activity

Total releases
3
First release
Jan 2025
Latest release
1 year ago
Releases (12 mo)
0 ▼ from 3
Maintenance
Dormant

Release Timeline

Releases

Version Type Release date
2.0.7 Stable Jun 19, 2025
2.0.6 Stable Jan 30, 2025
8.x-1.6 Stable Jan 30, 2025