Microsoft Excel is a spreadsheet developed by Microsoft for Windows OS.
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 and PmaDatabase objects). To access this row it is necessary to set the following in the Windows register:
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 types.

The database can be filled:
- by the PmaAdo object via the ADO Provider Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb) or Microsoft.Jet.OLEDB.4.0.
- by the PmaDatabase object.
- or in the script by the GetObject method. See Examples of the work with applications excel

For next descriptions to the Microsoft Excel, see:
PROMOTIC 9.0.21 SCADA system documentation - MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r. o.