is a spreadsheet developed by Microsoft for OS Windows
The default formats for Excel are the *.xls or *.xslx files.
Work with Excel database
- In the default setting of the Windows
register it is supposed that the first row of any Excel
table contains column names. It is shown so that the possible first row of the table is not accessible (e.g. for the PmaAdo
objects). To access this row it is necessary to set the following in the Windows
in the key HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Excel change the value FirstRowHasNames from the value 01 (default) to 00.
- In the Excel table (sheet) the rows cannot be deleted.
- By means of the PmaDatabase
object it isn't possible to read or write into cells in the Excel
table (sheet) if this cell is defined as calculated.
- If the PmaDatabase
object writes into the cells of the Excel
table (sheet) over which calculations are made or graphs are displayed, then it is suitable to set the "Database type
" configurator to Excel 4.0
in the PmaDatabase
object by reason of the error in MS support of data type writing for other Excel
The database can be filled:
- by the PmaAdo
object via the ADO Provider Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)
For next descriptions to the Microsoft Excel, see: