PHP Classes
elePHPant
Icontem

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


  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
Support forum Support forum
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)
 
  Groups   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


  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.