Export Spreadsheets
| Recommend this page to a friend! |  Stumble It! |
 Bookmark in del.icio.us |
| 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..
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 .zip .tar.gz | > |  Support forum (3) |
> |  Blog |
> |   Latest changes |
||
|
|||||||||||||||||||||||
| Groups | Freshmeat project |  User ratings |
Applications |  Files |
||||||
| Groups | ||
 |
PHP 5 | Classes using PHP 5 specific features | View top rated classes |
|
Databases | Database management, accessing and searching | View top rated classes |
|
Files and Folders | Listing, accessing and manipulating files and folders | View top rated classes |
| Freshmeat project | ||
| Project record: | exportspreadsheets |
|---|---|
| Popularity score: | 18.49 |
| Vitality score: | 33.93 |
| User ratings | ||
| Ratings | ||||||||
|---|---|---|---|---|---|---|---|---|
| All time: | ||||||||
| Month: | ||||||||
| Applications that use this class | ||
No application links were specified for this class.
If you know an application of this package, send a message to the author to add a link here.| Files |
||
| File | Role | Description |
|---|---|---|
 copying.txt |
Lic. | GPL License |
| exportSpreadsheetConditions.html |
Doc. | Documents input conditions and resulting output |
| createExportDatabase.sql |
Data | SQL to create test database, table, and user |
| regressionTests.php |
Example | Demonstrates 16 input combinations for the class |
| exportComplexQueries.php |
Example | Demonstrates use of complex queries and row formulas |
 exportSpreadsheetsClass.html |
Doc. | Documentation on how to use the class |
| export_fancy.php |
Example | Exports a spreadsheet with 3 worksheets |
| export_simple.php |
Example | Simple export example |
| export_spreadsheets_class.php |
Class | The exportSpreadsheets PHP class |
| Download all files: export-spreadsheets.tar.gz export-spreadsheets.zip |
For more information send a message to info at phpclasses dot org.
Copyright (c) Icontem 1999-2013