Top rated packages with tag spreadsheet

Recommend this page to a friend!

			All class groups	>	Search tags: spreadsheet

	1. Export Spreadsheets		spreadsheet

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

Supplied by: Xavier Noguer <e-mail contact>

Classes for generating Excel files

Class for generating Excel files (without using COM), based on John McNamara's Spreadsheet::WriteExcel from CPAN.
It supports all the basic values for cells (strings, numbers).
It has support for fomulas, images (bmp) and URL's.
It doesn't support charts (I might look into this if there is any interest).

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Good (92.4%)`	`Good (85.9%)`	`-`	`Sufficient (77.9%)`	`-`	`-`	`Sufficient (62.6%)`	595
Month:	Not yet rated by the users

	3. MS-Excel Stream Handler		spreadsheet

Supplied by: Ignatius Teo <e-mail contact>

Stream wrapper to read and write MS Excel files

This class implements a stream handler interface to read and write Microsoft Excel spreadsheet files in the XLS format.

XLS files may be read and written using PHP fopen, fread or fwrite, or any other PHP functions that can access to streams.

The file name has the format xlsfile://path/to/spreadsheet.xls where /path/to/spreadsheet.xls is the path of the actual spreadsheet file to be read or written.

To create a XLS file just pass a serialized array of spreadsheet row arrays that associate the column names with their values.

In the current version the class does not process the data read from a XLS file. Instead it just returns the raw XLS file data as is.

This class requires at least PHP 4.3.0 as that is the version when stream handling support was introduced in PHP.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Sufficient (76.4%)`	`Sufficient (71.4%)`	`Sufficient (65.5%)`	`Sufficient (69.1%)`	`-`	`-`	`Not sure (58.8%)`	894
Month:	Not yet rated by the users

	4. Create Multiple spreadsheet xls file		spreadsheet

Supplied by: Prashant Bhavsar <e-mail contact>

Create Multiple spreadsheet xls file

This class can be used to create Multiple spreadsheets xls file format.

Which can be open in openoffice, Excel viewer and also in others latest editors.

Here you can customize cloumn's name,size,color,width of xls file.It will create xml file and open that file in xls or save as xls..it works perfect.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Good (83.3%)`	`Good (83.3%)`	`-`	`Not sure (58.3%)`	`-`	`-`	`Not sure (55.8%)`	1084
Month:	Not yet rated by the users

	5. ods-php		spreadsheet

Supplied by: Jose Carlos Norte <e-mail contact>

Read and write spreadsheet files in the ODS format

This class can be use to read and write spreadsheet files in the Open Document Spreadsheet (ODS) Format used by OpenOffice.

It can create spreadsheets by adding or changing the values of the cells, rows or formulas.

The class can create the spreadsheet files by generating the document XML files in its directory structure and then using the zip command to generate a single packed archive in the ODS compressed format.

It can also do the opposite by extracting a ODS zip archive and parsing the spreadsheet XML files to extract the cell data values into class variables.

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

	6. OpenOffice Spreadsheet Generation		spreadsheet

Supplied by: rekam <e-mail contact>

Generate of OpenOffice spreadsheet documents

This package can be used to generate spreadsheet documents in the OpenOffice format.

It uses template XML files to generate the different parts of an OpenOffice spreadsheet document: table cell contents, styles, settings, metadata and manifest.

The templates are processed and the output XML part is generated according to the contents of the spreadsheet defined by the application.

To see some examples and how-to-use informations, please visit the website (in french only) :
http://membres.lycos.fr/tafelmak/

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Sufficient (75.0%)`	`Sufficient (60.0%)`	`-`	`-`	`-`	`-`	`Not sure (43.5%)`	1849
Month:	Not yet rated by the users

	7. Easy Excel		spreadsheet

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		spreadsheet

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

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