Php SpreadSheet is the best php library for reading and writing excel files. In many of our WordPress projects we use this library for export data as excel. As now wordpress.org doesn’t allow this type library as plugin we thought to create it as a plugin and host in github. Even, the whole library has lots of files which creates problem while releasing new version via svn. For easy distribution and to keep the main plugin fat free we released the library as wordpress plugin via github, please check here

Requirements

The following software is required to develop using PhpSpreadsheet:

  • PHP version 5.6 or newer
  • PHP extension php_zip enabled
  • PHP extension php_xml enabled
  • PHP extension php_gd2 enabled (if not compiled in)

The plugin check the above requirement on activate. The good thing about this plugin is it doesn’t preload or load anything unless you load the package in your plugin.

Download & Install

Go to release page and download the latest release zip package(that has name “cbxphpspreadsheet.zip”) and install via your wordpress plugin manager. If you don’t know how to install custom plugin please follow this guide from wordpress documentation.

How to Use(For advance user)

Note: If you want to use this library in your project

https://gist.github.com/manchumahara/827675e49a73c53596ae729e7d39d440

List of our plugins using this library for excel(ods, xls, xlsx) export