Change Log

Version 8.5.0 #

  1. Add "removeDuplicate" for Table widget.
  2. Add "excelFormatCode" for Table's column meta.
  3. Bug fix for Table's row group builder.
  4. Bug fix for Table's number format code.
  5. Add group value argument to excelStyle's "rowGroup" style.

Version 8.0.1 #

  1. Change PHPSpreadSheet version to work with PHP 7.1

Version 8.0.0 #

  1. Add rowGroup property for exporting Table widget to excel and big spreadsheet.
  2. Fix Chart bug not showing in MS Excel since PHPSpreadsheet 1.10

Version 7.2.0 #

  1. Several bug fixes for chart axis and big spreadsheet's column setting.
  2. Add more axis options for excel chart.
  3. Add "hideChartDataSheet" setting when exporting with excel template.
  4. Update "phpoffice/phpspreadsheet" and "box/spout" versions.

Version 7.1.1 #

  1. Fix bug for ExportHandler when data is empty.

Version 7.1.0 #

  1. Fix PieChart and some single-series charts to be correct format in MS Office.

Version 7.0.0 #

  1. Add BigSpreadsheetDataSource to read huge excel, ods and csv files.
  2. Add BigSpreadsheetExportable trait to export to huge excel, ods and csv files.

Version 6.0.0 #

  1. Change excel template file from .excel.php to standard .view.file
  2. Add "filtering", "sorting", "paging", "showHeader", "showBottomHeader", "shotFooter", "map" and "excelStyle" to Excel's Table widget
  3. Add "hideSubTotalRows", "hideSubTotalColumns", "hideGrandTotalRow", "hideGrandTotalColumn", "showDataHeaders" and "excelStyle" to Excel's PivotTable widget
  4. Add Excel's Text widget

Version 5.1.0 #

  1. Internal: move functions from exportable trait to export handler object to prevent polluting report object
  2. Fix excel export column order problem

Version 5.0.0 #

  1. Export to Excel using php template file.
  2. Support text, table, pivot table and multiple chart types in template export.
  3. Customize style including font, alignment, border and fill for text, table.

Version 3.2.0 #

  1. CSVExportable: Adding BOM options.

Version 3.0.0 #

  1. CSVExportable: New trait allows exporting to CSV files.
  2. Add option like 'columns' for ExcelExportable.

Version 2.1.0 #

  1. ExcelDataSource: Add: sheetName and sheetIndex properties for loading only those sheets.

Get started with KoolReport

KoolReport will help you to construct good php data report by gathering your data from multiple sources, transforming them into valuable insights, and finally visualizing them in stunning charts and graphs.