Skip to main content
Drupal is a registered trademark of Dries Buytaert
Release: OpenID Connect / OAuth client 3.0.0-alpha9 New alpha version released for module openid_connect (3.0.0-alpha9). Usage Milestone: Google Analytics Module google_analytics crossed 1,000 active installs. Release: Timelinr 1.0.1 Minor update available for module timelinr (1.0.1). Release: GraphQL Compose Codegen 1.1.2 Minor update available for module graphql_compose_codegen (1.1.2). Release: Mapy.com 1.1.3 Minor update available for module mapycom (1.1.3). Release: Ckeditor5 entity browser 3.0.3 Minor update available for module ckeditor5_entity_browser (3.0.3). Release: Ckeditor5 entity browser 3.0.1 Minor update available for module ckeditor5_entity_browser (3.0.1). Release: Ckeditor5 entity browser 3.0.2 Minor update available for module ckeditor5_entity_browser (3.0.2). Release: Teamleader Integration 4.0.2 Minor update available for module teamleader (4.0.2). Module Revived: Entityqueue Buttons 1.1.2 Module entityqueue_buttons updated after 8 months of inactivity (1.1.2).

Data export phpspreadsheet

783 sites Security covered Drupal 10–11 Views ecosystem
View on drupal.org

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 ☕.

Depends on

Dependencies of the latest stable release

  • rest Drupal core
  • views Drupal core
  • views_data_export Drupal core

Required by

Tracked projects that depend on this one

No tracked projects depend on this one yet.

Activity

Tracked releases
4
Tracked since
Nov 2024
Latest release
1 year ago
Releases (12 mo)
0 ▼ from 4
Maintenance
Dormant

Release Timeline

Releases

Version Type Core Release date
2.0.7 Stable 10–11 Jun 19, 2025
2.0.6 Stable 10–11 Jan 30, 2025
8.x-1.6 Stable 8–10 Jan 30, 2025
2.0.5 Stable 9–11 Nov 28, 2024