Skip to content
Snippets Groups Projects
Select Git revision
  • master default protected
  • fixCommaFilename
  • 2.6.0
  • 2.5
  • 2.4
  • 2.3
  • 2.2
  • 2.1
  • 2.0-beta1
  • 1.10
  • 1.9
  • 1.8
  • 1.7
  • 1.6
  • 1.4
  • 1.3
  • 1.2
  • 1.1
18 results
Compare
Mathieu Lu's avatar
CiviReport Export: fix bug when reports have a comma in their title
bgm authored 
Mostly seen in Chrome-based browsers (not Firefox) on Windows.
If a report has a comma in the title, then the browser does not
recognize the file type.
a1dfb851
History
Mathieu Lu's avatar a1dfb851
History
Name Last commit Last update
CRM/CiviExportExcel
Civi
l10n
settings
templates/CRM
xml/Menu
.gitignore
.gitlab-ci.yml
LICENSE.txt
README.md
civiexportexcel.civix.php
civiexportexcel.php
composer.json
composer.lock
info.xml
README.md

CiviCRM export to Excel

This extension adds the possibility to export directly into the MS Excel format from CiviReports and Search results, instead of CSV (less fiddling, easier to use).

This extension uses the PhpSpreadsheet library. See the "License" section below for more information (LGPL).

To download the latest version of this module:
https://lab.civicrm.org/extensions/civiexportexcel/

This extension is maintained by Coop SymbioTIC.

Sponsors:

Warnings

  • This extension does not run the buildACLClause() function, meaning that you may have deleted contacts show up in some reports. If you are using ACLs in general, this can also cause important issues.

Requirements

  • CiviCRM >= 5.29

Installation

1- Download this extension and unpack it in your 'extensions' directory. You may need to create it if it does not already exist, and configure the correct path in CiviCRM -> Administer -> System -> Directories.

2- If installing from git, run composer install.

3- Enable the extension from CiviCRM -> Administer -> System -> Extensions.

Report mails

To send report e-mails in Excel2007 format, use: "format=excel2007" in the "Scheduled Jobs" settings.

Support

Please post bug reports in the issue tracker of this project on CiviCRM's Gitlab:
https://lab.civicrm.org/extensions/civiexportexcel/issues

For general questions and support, please post on Stack Exchange:
https://civicrm.stackexchange.com/

This is a community contributed extension written thanks to the financial support of organisations using it, as well as the very helpful and collaborative CiviCRM community.

If you appreciate this extension, please consider financially supporting the CiviCRM project by becoming a member, a partner or a one-time donation:
https://civicrm.org/support-us

While we do our best to provide volunteer support for this extension, please consider financially contributing to support or development of this extension if you can.

Commercial support via Coop SymbioTIC:
https://www.symbiotic.coop/en

Todo

  • Add OpenDocument (LibreOffice) support.
  • Add admin settings form to enable excel/opendocument formats?

License

(C) 2014-2020 Mathieu Lutfy mathieu@symbiotic.coop
(C) 2018-2020 Coop SymbioTIC info@symbiotic.coop

Distributed under the terms of the GNU Affero General public license (AGPL). See LICENSE.txt for details.

This extension relies on phpSpreadsheet by PHPOffice:
https://github.com/PHPOffice/PhpSpreadsheet

See composer.json for more information about dependencies.