Importing one column from an Excel worksheet that has multiple columns and want to start the import 10 rows down.
'column name as header' is unchecked
When moving away from 'auto' to select the column for import, it shows as column 3 when in fact it's column 4 in the worksheet
similar issue with the row start. I specify to start at row 1. This in fact starts at row 2, so when the import is done, it's missing the first row.
Also it's not possible to type in the row number. You have to use the dropdown to increment which is not efficient if you want start at row number 250, for example
WORKAROUND
for column selection, ensure that you specify column y-1
for row selection, ensure that you select row x-1 (If you want to start at row 1, then keep 'auto' selection in place
STATUS
Waitng for fix in a future release of Toad for Data Analysts.
