Export Spreadsheets: Create Excel spreadsheet from data in MySQL table
| Recommend this page to a friend! |
 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 |  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 |
| User ratings |
| Ratings | Utility | 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.
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 |
 Install with Composer - Download all files: export-spreadsheets.tar.gz export-spreadsheets.zipNOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.
|
| 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 |
| Install with Composer - 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.
|
