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.
- by the
PmaAdo object via the
ADO Provider Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb) or
Microsoft.Jet.OLEDB.4.0.
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 and 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 and Excel 4.0 macro sheets (.xlm). |
| Excel 97- Excel 2003 Workbook |
.xls |
Binary format of the Excel 97-2003 (BIFF8) file. Also supported in Excel 2007-2021. |
| Excel 97-2003 Template |
.xlt |
The Excel 97-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. |