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 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

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: 68
All time rank: 954132 in United States United States
Week rank: 262 Up23 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

 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:461
 
quick and simple
12 years ago (Vipul Patel)
80%StarStarStarStarStar
This works and is useful
12 years ago (Geoff Stacey)
75%StarStarStarStar
This is really nice class.
14 years ago (nish)
65%StarStarStarStar