> A reasonable alternative would be for example statically typing each column or row in the sheet.

You can actually statically type the columns now for imported data via the PowerQuery editor (which is built into Excel), although not a lot of people know how to use it.