PHP Export Table to Excel: Generate Excel file from database table SQL query

Recommend this page to a friend!
  Info   View files Example   View files View files (6)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2021-04-01 (11 days ago) RSS 2.0 feedNot yet rated by the usersTotal: 119 This week: 30All time: 9,267 This week: 5Up
Version License PHP version Categories
phpdbtabletoexcel 1.0.0Custom (specified...5PHP 5, Databases, Files and Folders
Description Author

This package can generate Excel file from database table SQL query.

It can connect to a database using PDO and executes a given SQL database table query.

The class executes the query and then outputs the results to a file in HTML table based format that is served for download and can be read and imported correctly by Microsoft Excel.

Picture of shamsh parvez
  Performance   Level  
Name: shamsh parvez <contact>
Classes: 1 package by
Country: India India
Age: ???
All time rank: 4262300 in India India
Week rank: 10 Up1 in India India Up

Details

PHPDBTabletoExcel

Create Excel sheet directly from database table rows

  Files folder image Files  
File Role Description
Files folder imagesrc (2 directories)
Accessible without login Plain text file composer.json Data Auxiliary data
Accessible without login Plain text file composer.lock Data Auxiliary data
Accessible without login Plain text file LICENSE Lic. License text
Accessible without login Plain text file README.md Doc. Documentation

  Files folder image Files  /  src  
File Role Description
Files folder imageclass (1 file)
Files folder imagedemo (1 file)

  Files folder image Files  /  src  /  class  
File Role Description
  Plain text file Excel.php Class Class source

  Files folder image Files  /  src  /  demo  
File Role Description
  Accessible without login Plain text file index.php Example Example script

 Version Control Unique User Downloads Download Rankings  
 100%
Total:119
This week:30
All time:9,267
This week:5Up

For more information send a message to info at phpclasses dot org.