Top rated packages with tag excel

Recommend this page to a friend!

			All class groups	>	Search tags: excel

	1. Export Spreadsheets		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. Native Excel Reader		excel

Supplied by: Ruslan V. Uss <e-mail contact>

Parse and access binary Excel files in pure PHP

This package can be used to parse and access binary Excel files in pure PHP.

It can take the data of an Excel file in the binary format and parse it to take the spreadsheet structure.

The package provides several classes that extract the different parts of a spreadsheet and allow iterating those parts like workbooks, sheets, rows, columns and cells.

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

	3. Excel		excel

Supplied by: alain samoun <e-mail contact>

Manipulate Excel files using the COM interface

Implements the basic functionalities of Excel in PHP4 using the COM interface.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Good (80.8%)`	`Sufficient (73.8%)`	`Sufficient (71.7%)`	`Sufficient (75.6%)`	`-`	`-`	`Sufficient (62.5%)`	597
Month:	Not yet rated by the users

	4. Export To Excel		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.

	5. Excel XML Parser		excel

Supplied by: Andrew Aculana <e-mail contact>

Read and write data to Excel XML worksheets

This package can be used to read and write data to Excel worksheets in the Excel XML format.

It can parse an Excel document file in the XML format and create objects to access the file workbook, worksheets, table, cells, etc..

The contents of the document may also be altered and saved to an Excel XML file or served for download.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Good (82.1%)`	`Sufficient (78.6%)`	`-`	`Not sure (55.4%)`	`-`	`-`	`Not sure (54.5%)`	1184
Month:	Not yet rated by the users

	6. Excel convertor		excel

Supplied by: Umesh Rai <e-mail contact>

Read data from Excel files using COM objects

This package is meant to read the data from an MS office 2000 Excel 97 file using Windows COM objects.

The class can traverse a given worksheet and read the information from a given cell range.

An example is provided to demonstrate how the class can be used to output the worksheet data in an HTML table.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Not sure (52.1%)`	`Not sure (54.2%)`	`Sufficient (68.2%)`	`Not sure (54.2%)`	`-`	`-`	`Not sure (43.7%)`	1840
Month:	Not yet rated by the users

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

	8. Excel Reader		excel

Supplied by: khalil Majdalawi <e-mail contact>

Access Excel spreadsheets as databases using ODBC

This class can be used to access Excel spreadsheets like databases using ODBC.

It opens an Excel spreadsheet using ODBC given a previously defined DSN (data source name) pointing to an existing Excel spreadsheet file.

It can execute queries to retrieve the list of sheets in a spreadsheet, retrieve the names of columns in each sheet, retrieve the data in the sheet cells as an array or display it as an HTML table.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Not sure (50.0%)`	`Not sure (55.0%)`	`Not sure (50.0%)`	`Not sure (56.2%)`	`-`	`-`	`Not sure (41.1%)`	1927
Month:	Not yet rated by the users

	9. MySql To Excel		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