PHP Classes

Export Spreadsheets: Create Excel spreadsheet from data in MySQL table

Recommend this page to a friend!

  Author Author  
Picture of Charles A. LaFleur
Name: Charles A. LaFleur <contact>
Classes: 1 package by
Country: United States United States
Age: 67
All time rank: 954130 in United States United States
Week rank: 503 Up50 in United States United States Up


  Detailed description   Download Download .zip .tar.gz   Install with Composer Install with Composer  
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..

  Classes of Charles A. LaFleur  >  Export Spreadsheets  >  Download Download .zip .tar.gz  >  Support forum Support forum (3)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: Export Spreadsheets
Base name: export-spreadsheets
Description: Create Excel spreadsheet from data in MySQL table
Version: 2.2
PHP version: 3.0
License: GNU General Public License (GPL)
All time users: 3342 users
All time rank: 1032
Week users: 0 users
Week rank: 291 Equal
 
  Groups   Rate classes User ratings   Applications   Files Files  

  Groups  
Group folder image PHP 5 Classes using PHP 5 specific features View top rated classes
Group folder image Databases Database management, accessing and searching View top rated classes
Group folder image Files and Folders Listing, accessing and manipulating files and folders View top rated classes


  User ratings  
RatingsUtility Consistency Documentation Examples Tests Videos Overall Rank
All time: Good (90%) Good (85%) Good (95%) Good (95%) - - Sufficient (72%) 261
Month: Not yet rated by the users

  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.

  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

Install with Composer Install with Composer - Download Download all files: export-spreadsheets.tar.gz export-spreadsheets.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.
  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

Install with Composer Install with Composer - Download Download all files: export-spreadsheets.tar.gz export-spreadsheets.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.