Code

MySQL Data to Excel Export

MySQL Data to Excel Export

MySQL Data to Excel Export is simple web report export tool, you do can use MySQL Data to Excel Export tool for excel file.It can be easily customized as like page setup, set page margins, center page, show/hide gridlines, worksheet name, font, font size, cells fill color, cells border color, text alignment vertical, text alignment horizontal and cells width easily changeable. Excel cells is set number formats and data validation. MySQL Data is showing rows group wise and header(rows and columns merge).You can protected and unprotected easily set on excel worksheet cells.

\\

Export Functionalities

  • Basic
  • Row Grouping
  • Header (Rows and Columns Merge)
  • Autofilter Range of Cells
  • Formula Calculations
  • Protected and Unprotected on Cells
  • Image with Description

Include

  • All files
  • Documentation

Third party software

  • Bootstrap
  • JQuery
  • PhpSpreadsheet
  • PHPExcel

Credit

Software requirements (For PhpSpreadsheet)

  • PHP version 5.6 or newer
  • PHP extension php_zip enabled
  • PHP extension php_xml enabled
  • PHP extension php_gd2 enabled
  • PDO PHP Extension
  • MySQLi Extension

Releases

- v2.0 17/08/2018 
- Added feature. 
- Added Image with Description. 
- Migration from PHPExcel - PhpSpreadsheet. 
- v1.0 18/01/2018 
- Added feature. 
- Added PDO PHP Extension. 
- Added MySQLi Extension. 

Support

If you have any questions about this MySQL Data to Excel Export, please feel free to contact with me via email : tspprt7@gmail.com
Thanks so much!

by
by
by
by
by
by