ExcelTable is an Oracle SQL interface to read Microsoft Excel files (.xlsx, .xlsm, .xlsb, .xls, .xml), ODF spreadsheet files (.ods) and flat files as external tables
Strings beginning with a single apostrophe ' are stored with a cell style having a quotePrefix attribute set to true.
The leading apostrophe itself is not stored, only the rest of the string.
ExcelTable does not handle this correctly.
Strings beginning with a single apostrophe
'are stored with a cell style having a quotePrefix attribute set to true. The leading apostrophe itself is not stored, only the rest of the string. ExcelTable does not handle this correctly.