PHP Classes

Excel Reader: Access Excel spreadsheets as databases using ODBC

Recommend this page to a friend!

  Author Author  
Name: khalil Majdalawi is available for providing paid consulting. Contact khalil Majdalawi .
Classes: 1 package by
Country: Jordan Jordan
Age: 35
All time rank: 2581 in Jordan Jordan
Week rank: 1104 Down5 in Jordan Jordan Down
Innovation award
Innovation award
Nominee: 1x

  Detailed description   Download Download .zip .tar.gz   Install with Composer Install with Composer  
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.

1: create excel file then create range for you data in the excel sheet name it 'myrange'
make odbc connection "SYSTEM DSN " using  Microsoft Excel Driver name it 'employees_list' then run the example

  Classes of khalil Majdalawi  >  Excel Reader  >  Download Download .zip .tar.gz  >  Support forum Support forum (1)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: Excel Reader
Base name: excel_reader
Description: Access Excel spreadsheets as databases using ODBC
Version: 1.0
PHP version: 4.3.4
License: Free for non-commercial use
All time users: 9285 users
All time rank: 159
Week users: 0 users
Week rank: 616 Equal
  Groups   Rate classes User ratings   Applications   Files Files  

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

  Innovation Award  
PHP Programming Innovation award nominee
March 2007
Number 3

Prize: One copy of DWebPro Standard License
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

  User ratings  
RatingsUtility Consistency Documentation Examples Tests Videos Overall Rank
All time: Not sure (50%) Not sure (55%) Not sure (50%) Not sure (56%) - - Not sure (41%) 2861
Month: Not yet rated by the users

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.

  Files folder image Files  
File Role Description
Plain text file odbcManager Class ODBC Manager
Accessible without login Plain text file readme Doc. readme
Accessible without login Plain text file simple Example Example

Install with Composer Install with Composer - Download Download all files: excel_reader.tar.gz
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.