Databases: Excel Reader
khalil Majdalawi (contact me)
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.
| Utility
| Consistency
| Docs
| Examples
| Tests
| Videos
| Overall
| Rank
|
| Not sure (50.0%)
| Not sure (55.0%)
| Not sure (50.0%)
| Not sure (56.3%)
| -
| -
| Not sure (41.1%)
| 1620 |
Click here for detailed information about this class on phpclasses.org