PHP Classes

Excel Reader: Access Excel spreadsheets as databases using ODBC

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 40%Total: 9,336 All time: 161 This week: 488Down
Version License PHP version Categories
excel_reader 1.0Free for non-comm...4.3.4Databases, Files and Folders
Description 

Author

khalil Majdalawi

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.

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
Picture of khalil Majdalawi
Name: khalil Majdalawi is available for providing paid consulting. Contact khalil Majdalawi .
Classes: 1 package by
Country: Jordan Jordan
Age: 42
All time rank: 2661 in Jordan Jordan
Week rank: 195 Up2 in Jordan Jordan Down
Innovation award
Innovation award
Nominee: 1x

Details

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

  Files folder image Files (3)  
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

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadexcel_reader-2007-03-21.zip 1KB
Downloadexcel_reader-2007-03-21.tar.gz 1KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:9,336
This week:0
All time:161
This week:488Down
 User Ratings  
 
 All time
Utility:50%StarStarStar
Consistency:54%StarStarStar
Documentation:50%StarStarStar
Examples:55%StarStarStar
Tests:-
Videos:-
Overall:40%StarStarStar
Rank:3768
  

  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.