PHP Classes
Icontem

Class: Excel Reader


  Search   All class groups All class groups   Latest entries Latest entries   Top 10 charts Top 10 charts   Newsletter Newsletter   Blog Blog   Forums Forums   Help FAQ Help FAQ  
  Login   Register  
Recommend this page to a friend! ReTweet ReTweet Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of khalil Majdalawi  >  Excel Reader  >  Download  >  Support forum Support forum (1)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: Excel Reader Support forum
Base name: excel_reader
Description: Access Excel spreadsheets as databases using ODBC
Related top rated classes: , , ,
Version: 1.0
Required PHP version: 4.3.4
License: Free for non-commercial use
All time users: 6136 users
All time rank: 188
Week users: 32 users
Week rank: 135
 
  Author   Group folder image Groups   Detailed description  
  Rate classes User ratings   Applications   Files Files  

Author

Picture of khalil Majdalawi
Name: khalil Majdalawi is available for providing paid consulting. Contact khalil Majdalawi .
Published packages: 1 Browse this author's classes Browse this author's classes
Country: Jordan Jordan - PHP jobs in Jordan
Home page: http://dev3k.com/
Age: 27
All time rank: 271
Week rank: 178

Innovation Award

PHP Programming Innovation award nominee
March 2007
Number 3
 Excel is a very popular application used often as personal database program. Users enter tabular data that is often important to run their businesses.

Excel stores spreadsheets in proprietary format files. This makes it more difficult for external applications to access and process data stored in Excel spreadsheets.

An alternative solution to read Excel files is to use the ODBC API in a system with Excel drivers.

This class uses the ODBC API to retrieve data from Excel spreadsheets, thus simplifying the implementation of applications that need to retrieve information entered by users of the Excel program.

Manuel Lemos

Groups

Group folder image Databases Database management, accessing and searching View top rated classes
Group folder image Files and Folders Listing, accessing and manipulating files and folders View top rated classes

Detailed description

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.

User ratings

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.3%)
-
-
Not sure (41.1%)
1696
Month:
Not yet rated by the users

Applications that use this class

No application links were specified for this class.
Add link image If you know an application of this package, send a message to the author to add a link here.

Files

File Role Description
Plain text file odbcManager Class ODBC Manager
Plain text file readme Doc. readme
Plain text file simple Example Example
Download all files: excel_reader.tar.gz excel_reader.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.

 
  Advertise on this site Advertise on this site   Site map Site map   Statistics Statistics   Site tips Site tips   Privacy policy Privacy policy   Contact Contact  

For more information send a message to :
info at phpclasses dot org.
Copyright (c) Icontem 1999-2009 PHP Classes - PHP Class Scripts
  PHP Book Reviews - Reviews of books and other products