Top rated packages with tag mysql excel

Recommend this page to a friend!

			All class groups	>	Search tags: mysql excel

	1. Export Spreadsheets		mysql excel

Supplied by: Charles A. LaFleur <e-mail contact>

Create Excel spreadsheet from data in MySQL table

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

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Good (87.5%)`	`Good (81.2%)`	`Good (93.8%)`	`Good (93.8%)`	`-`	`-`	`Sufficient (70.6%)`	166
Month:	There are not enough user ratings to display for this class.

	2. Export To Excel		mysql excel

Supplied by: raju mazumder <e-mail contact>

Generate HTML tables from MySQL query results

This class can be used to generate HTML tables from MySQL query results to be downloaded as a file Microsoft Excel can read.

It executes a given MySQL query and generates an HTML table from the query result data.

The class can also generate the necessary request headers to make the outputted HTML be downloaded as file by the browser with a file name that makes the file be readable by Microsoft Excel.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Good (90.0%)`	`Good (85.0%)`	`-`	`Good (85.0%)`	`-`	`-`	`Sufficient (62.0%)`	665
Month:	There are not enough user ratings to display for this class.

	3. ADODB SQL 2 Excel		mysql excel

Supplied by: Rubens <e-mail contact>

Export SQL query results to Excel files with ADODB

This class can be used to generate Excel files in the XLS format from database query results.

This is an altered version of of the SQL 2 Excel class, originally provided by Dzaiacuck, that uses ADODB API instead of MySQL. It extends the GeraExcel class to generate Excel files from the results of execution of an SQL query.

It takes an SQL query string and the array of titles of columns of the Excel spreadsheet file to be generated.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Good (83.3%)`	`Good (83.3%)`	`-`	`Sufficient (75.0%)`	`-`	`-`	`Not sure (57.5%)`	986
Month:	Not yet rated by the users

	4. SQL to Excel		mysql excel

Supplied by: dzaiacuck <e-mail contact>

Export database table records in Excel XLS format

This package is meant to export spreadsheet information in the Excel XLS format.

It consists in a base class that is capable of generating the contents of an XLS file given the values of the spreadsheet cells. There is also a sub-class that can query a MySQL database and use the base class to generate the contents of XLS file with the information of the query result set.

The class code and comments are in Portuguese.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Good (83.8%)`	`Sufficient (69.1%)`	`-`	`Sufficient (75.0%)`	`-`	`-`	`Not sure (56.3%)`	1049
Month:	Not yet rated by the users

	5. sql2excel		mysql excel

Supplied by: Erh-Wen,Kuo <e-mail contact>

Easy way to stream Mysql sql content to Excel.

This class is designed to provide a easy way to output mysql sql content in Excel Format & stream it on the user's browser directly.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Good (89.8%)`	`Good (81.5%)`	`-`	`-`	`-`	`-`	`Not sure (53.1%)`	1295
Month:	Not yet rated by the users

	6. Easy Excel		mysql excel

Supplied by: Rafael de Pablo <e-mail contact>

Output Excel sheets and charts from data in MySQL

This class outputs Excel spreadsheets and charts from the data is obtained from a MySQL database using the Office Web Component objects from Microsoft.

The class generates HTML pages with the necessary VBScript code to define the contents of the Office Web component spreadsheet and chart objects.

To see the generated pages the user needs to use Internet Explorer and have installed Microsoft Office 2003.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Sufficient (61.7%)`	`Sufficient (65.0%)`	`-`	`Not sure (56.7%)`	`-`	`-`	`Not sure (43.0%)`	1873
Month:	Not yet rated by the users

	7. psxlsgen		mysql excel

Supplied by: Erol Ozcan <e-mail contact>

Generate simple MS Excel files (xls).

This project includes some classes which are used to generate very simple MS Excel file (xls) via PHP. The generated xls file can be obtained by web as a stream file or can be written under $default_dir path. It has very simple usage to generate xls file from a select query using mysql, pgsql, oci8 databases.
Limitation:
- Max character size of a text(label) cell is 255
( due to MS Excel 5.0 Binary File Format definition )

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Not sure (59.1%)`	`Sufficient (63.6%)`	`-`	`-`	`-`	`-`	`Insufficient (35.9%)`	2081
Month:	Not yet rated by the users

	8. MySql To Excel		mysql excel

Supplied by: Harish Chauhan <e-mail contact>

Export data from a MySQL database to Excel files

This class is used for exporting the data from a MySql to spreadsheet files in the Excel format.

The class executes a given database query and extract the result set data to generate the Excel spreadsheet.

The generated Excel spreadsheet can be stored in a given file or be made available immediately for download.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Not sure (50.0%)`	`Not sure (53.2%)`	`-`	`Not sure (51.3%)`	`-`	`-`	`Insufficient (35.4%)`	2095
Month:	Not yet rated by the users

Copyright (c) Icontem 1999-2012	PHP Classes	- PHP Class Scripts
	PHP Book Reviews	- Reviews of books and other products