Excel

Retrieve data from Excel file and export data to Excel.

Introduction

KoolReport's Excel is a great library to let you work with Excel file seamlessly. The package contains datasource to import data from Excel and a powerful engine to export data to Excel. If you store your data in several excel files, the excel package is able to load your data from those sources at once and produce a combination result. Then the result can be easily saved to another excel file.

An advanced feature of our Excel package is the ability to make Excel native charts and graphs using XML language. As a result, instead of of writing tedious code, you use more intuitive and familiar markup language to create your beautiful Excel file with table, charts and graphs.

Another great feature of our Excel package is the capability to work with very large Excel file. Different from other php spreadsheet library, our library is able to read/write data to file in stream. As a result, you can save both memory usage and increase the size of Excel file.

Documentation

The details of how to install and how to use Excel package can be found at our documentation.

Examples

  1. Read data from Excel
  2. Export to Excel using template
  3. Create Excel's Chart
  4. Export Pivot table to Excel
  5. Big Excel-file Exporting

Licenses

The package can be purchased per project under Regular License or Extended License. The Regular License is for project of which users are not charged for. The Extended License is used for commercial project of which users are charged for.

The package is also available in the KoolReport Pro which contains all our packages and allow you to use in unlimited projects.

User Reviews
(2)
Glourise
on Oct 3, 2017

Excellent!

fumitsuki
on Apr 3, 2018

PHPExcel is no longer maintained. It would be better to use PhpSpreadsheet(https://github.com/PHPOffice/PhpSpreadsheet).