When importing Excel sheet, there is an option to tick or not tick following - “Do not automatically offset imported range”. Can you explain exactly what this does?
There can be empty (i.e. not filled with data) rows or\and columns between top left corner of a spreadsheet and actual data.
By default, “Import Excel spreadsheet” action will skip those rows and columns and import only rows and columns which contain actual data. “Do not automatically offset imported range” checkbox changes this behavior and makes “Import Excel spreadsheet” action to additionally import those empty rows and column.
oh gosh, I had devised an entire ingenious solution to deal with exactly that issue, and here it was with just a click.