Microsoft Excel 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 PmAdo and PmDatabase 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 the PmDatabase 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 PmDatabase object writes into the cells of the Excel table (sheet) over which calculations are made or graphs are displayed, it is suitable to opt Database type configurator to Excel 4.0 in the PmDatabase object by reason of the error in MS support of data type writing for other Excel types.
The database can be filled:
- by the PmAdo object via the ADO Provider Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb) or Microsoft.Jet.OLEDB.4.0.
- by the PmDatabase object.
- or by script using the GetObject method. See Example of the work with applications excel
For next descriptions to the Microsoft Excel, see:
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice