PHP Classes

ADODB SQL 2 Excel: Export SQL query results to Excel files with ADODB

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 57%Total: 4,348 All time: 669 This week: 488Up
Version License Categories
adodbsql2excel 1.0GNU General Publi...Databases, Files and Folders
Description 

Author

This class can be used to generate Excel files in the XLS format from database query results.

This is an altered version of of the SQL 2 Excel class, originally provided by Dzaiacuck, that uses ADODB API instead of MySQL. It extends the GeraExcel class to generate Excel files from the results of execution of an SQL query.

It takes an SQL query string and the array of titles of columns of the Excel spreadsheet file to be generated.

Picture of Rubens
Name: Rubens <contact>
Classes: 1 package by
Country: Brazil Brazil
Age: ???
All time rank: 69151 in Brazil Brazil
Week rank: 180 Up12 in Brazil Brazil Up

  Files folder image Files (2)  
File Role Description
Plain text file example.inc.php Example simple example
Accessible without login Plain text file excel.inc.php Class The class

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:4,348
This week:0
All time:669
This week:488Up
 User Ratings  
 
 All time
Utility:83%StarStarStarStarStar
Consistency:83%StarStarStarStarStar
Documentation:-
Examples:75%StarStarStarStar
Tests:-
Videos:-
Overall:57%StarStarStar
Rank:1627