Export HTML Table Data to Excel, CSV, PNG and PDF using jQuery Plugin

Exporting data in to a format is a very common features in website.There is a lot of plugin which is used to export table data into xml,csv and png format but that will use for separate jquery file for each exporting format.

The tableExport is a wonderful jquery plugin which extracting table data into all formats like JSON , XML, PNG, CSV, TXT, SQL, MS-Word, Ms-Excel, Ms-Powerpoint and PDF, so with help of this jquery plugin you not need any other jquery plugin to extract data from tables.You can integrate tableExport plugin very easily with your project.

Here i will let you know basic use of tableExport jquery plugin with HTML table and with dynamic data using php and mysql.

Simple Example to extract table data into JSON XML,PNG,CSV,TXT,SQL,MS-Word,Ms-Excel,Ms-Powerpoint and PDF format using jquery and php

Simple Example to extract table data into JSON XML,PNG,CSV,TXT,SQL,MS-Word,Ms-Excel,Ms-Powerpoint and PDF format using jquery and php

We Can export HTML tables to the following formats:

  1. JSON
  2. XML
  3. PNG
  4. CSV
  5. TXT
  6. SQL
  7. MS-Word
  8. Ms-Excel
  9. Ms-Powerpoint
  10. PDF

How To Use table Export JQuery plugin :

following are basic files which you need to include into your head section of index.html file or Project. jquery plugin is necessary to tableExport jquery plugin.

How To Import Table data into PNG format:

we need to include html2canvas.js file into your head section to export table data into PNG format.

How To Import Table data into PDF format:

we need to include below files into your head section to export table data into PDF format.

Other option are:

  • separator: ‘,’
  • ignoreColumn: [2,3]
  • tableName:’yourTableName’
  • type:’csv’
  • pdfFontSize:14
  • pdfLeftMargin:20
  • escape:’true’
  • htmlContent:’false’
  • consoleLog:’false’

Other Type are:

You can also check other tutorial of Export Data with PHP,

How to use export table with php and mysql.

Here i will demonstrate integration of exportTable with php and mysql,its very easy and simple.We need to following below points to export html table data into Excel, CSV, JSON, PDF, PNG using jQuery,php and mysql.

Step 1: Include all necessary files of exportTable jquery plugin.

Step 2: Create PHP Connection with MYSQL database to get all records from database.

Step 3: Create UI of table grid and bind MYSQL records with HTML table.

Step 4: Call exportTable function to export data on click of format icon.

You can get more details from Official Website

You can download source code and Demo from below link