Excel Reader: Access Excel spreadsheets as databases using ODBC
| Recommend this page to a friend! |
 Author |
 |
|
Innovation award Nominee: 1x | ||||||||||
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.
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.
| Classes of khalil Majdalawi | > | Excel Reader | > |  Download .zip .tar.gz |
> |  Support forum (1) |
> |  Blog |
> |   Latest changes |
|
|||||||||||||||
| Groups | Applications |  Files |
| Groups |
 Databases |
Database management, accessing and searching | View top rated classes |
| Files and Folders |
Listing, accessing and manipulating files and folders | View top rated classes |
| Innovation Award |
 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 |
| Applications that use this package |
No pages of applications that use this class were specified.
If you know an application of this package, send a message to the author to add a link here.
| Files |
| File | Role | Description |
|---|---|---|
| odbcManager |
Class | ODBC Manager |
 readme |
Doc. | readme |
| simple |
Example | Example |
 Install with Composer - Download all files: excel_reader.tar.gz excel_reader.zipNOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.
|
For more information send a message to
info at phpclasses dot org.Copyright (c) Icontem 1999-2016