PHP Classes

Export Spreadsheets: Create Excel spreadsheet from data in MySQL table

Recommend this page to a friend!
     
  Info   View files View files (9)   DownloadInstall with Composer Download .zip   Reputation   Support forum (3)   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 72%Total: 3,344 All time: 1,031 This week: 190Up
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: 67
All time rank: 954132 in United States United States
Week rank: 578 Up70 in United States United States Up

  Files folder image Files  
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

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,344
This week:0
All time:1,031
This week:190Up
User Ratings User Comments (3)
 All time
Utility:90%StarStarStarStarStar
Consistency:85%StarStarStarStarStar
Documentation:95%StarStarStarStarStar
Examples:95%StarStarStarStarStar
Tests:-
Videos:-
Overall:72%StarStarStarStar
Rank:261
 
quick and simple
11 years ago (Vipul Patel)		80%StarStarStarStarStar
This works and is useful
11 years ago (Geoff Stacey)		75%StarStarStarStar
This is really nice class.
13 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.