Excel Imports: Hidden Rows

posted Jul 12, 2017, 4:14 AM by Eric Patrick
Frequently, power users observe that Excel-based imports result in more rows that present in Excel. This is generally a result of explicit or implicit ranges being created in Excel, which in turn are exposed to the OldDb drives provided by Microsoft. This is a problem Quandis cannot fix; the workaround is to save the spreadsheet as a CSV file, and the re-save it as an Excel spreadsheet.

For some of these use cases, issuing a SELECT DISTINCT * FROM {Sheet} will ignore the extra rows.

The ExcelEngine and OldDbEngine classes have been modified to optionally do this, and the default behavior is set to True. This means that if you intentionally want to import duplicate rows, you must explicitly tell the Import File Template to ignore this option:

ImportFile/Import?ID=X&UseDistinct=false


Comments