Promotic

Excel

Microsoft Excel is a spreadsheet developed by Microsoft for Windows OS.
The default formats for Excel are the *.xls or *.xlsx 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:

Excel file formats:

Format File extension Description
Excel Workbook .xlsx The default XML-based file format for Excel 2007 - 2021. Cannot store Microsoft Visual Basic for Applications (VBA) macro code or Microsoft Office Excel 4.0 macro sheets (.xlm).
Excel Macro-Enabled Workbook (code) .xlsm The XML-based and macro-enabled file format for Excel 2007 - 2021. Stores VBA macro code or Excel 4.0 macro sheets (.xlm).
Excel Binary Workbook .xlsb The binary file format (BIFF12) for Excel 2007 - 2021.
Template .xltx The default file format for an Excel template for Excel 2007 - 2021. Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm).
Template (code) .xltm The macro-enabled file format for an Excel template Excel 2007 - 2021. Stores VBA macro code or Excel 4.0 macro sheets (.xlm).
Excel 97- Excel 2003 Workbook .xls The Excel 97 - Excel 2003 Binary file format (BIFF8).
Excel 97- Excel 2003 Template .xlt The Excel 97 - Excel 2003 Binary file format (BIFF8) for an Excel template.
XML Data .xml XML Data format.
Formats supported by add-ons .xlam, XLA, XLW, .xlr Formats requiring installation of a separate add-in for a specific version of Excel.
PROMOTIC 9.0.24 SCADA system documentation MICROSYS, spol. s r.o.

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