PHP Classes

Export Spreadsheets: Create Excel spreadsheet from data in MySQL table

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
StarStarStarStar 67%Total: 3,348 All time: 1,032 This week: 455Up
Version License PHP version Categories
export-spreadsheets 2.2GNU General Publi...3.0PHP 5, Databases, Files and Folders
Description 

Author

Charles A. LaFleur

This class can be used to create an Excel spreadsheet from data in a MySQL table.

It performs a query to a given MySQL table and creates an Excel spreadsheet file with the PEAR Spreadsheet_Excel_Writer package from the table data.

The class can add multiple worksheets from results of querying one or more MySQL tables.

Several parameters may be used to configure details like from which table fields map to spreadsheet columns, field sorting, etc..

Picture of Charles A. LaFleur
Name: Charles A. LaFleur <contact>
Classes: 1 package by
Country: United States United States
Age: 69
All time rank: 955135 in United States United States
Week rank: 195 Up19 in United States United States Up

  Files folder image Files (9)  
File Role Description
Accessible without login Plain text file copying.txt Lic. GPL License
Accessible without login Plain text file exportSpreadsheetConditions.html Doc. Documents input conditions and resulting output
Accessible without login Plain text file createExportDatabase.sql Data SQL to create test database, table, and user
Accessible without login Plain text file regressionTests.php Example Demonstrates 16 input combinations for the class
Accessible without login Plain text file exportComplexQueries.php Example Demonstrates use of complex queries and row formulas
Accessible without login HTML file exportSpreadsheetsClass.html Doc. Documentation on how to use the class
Accessible without login Plain text file export_fancy.php Example Exports a spreadsheet with 3 worksheets
Accessible without login Plain text file export_simple.php Example Simple export example
Plain text file export_spreadsheets_class.php Class The exportSpreadsheets PHP 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
Downloadexport-spreadsheets-2012-01-20.zip 37KB
Downloadexport-spreadsheets-2012-01-20.tar.gz 36KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:3,348
This week:0
All time:1,032
This week:455Up
User Ratings User Comments (3)
 All time
Utility:83%StarStarStarStarStar
Consistency:79%StarStarStarStar
Documentation:87%StarStarStarStarStar
Examples:87%StarStarStarStarStar
Tests:-
Videos:-
Overall:67%StarStarStarStar
Rank:468
 
quick and simple
13 years ago (Vipul Patel)		80%StarStarStarStarStar
This works and is useful
13 years ago (Geoff Stacey)		75%StarStarStarStar
This is really nice class.
15 years ago (nish)		65%StarStarStarStar
 

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.