Hi, I have xlsx files loading into a QV model. The script allows for 12 header lines:
(ooxml, embedded labels, header is 12 lines,table is [$(vSheetName)] ).
My problem is that unless the excel file is first opened and saved, QV cannot work out how many header rows there are and the script errors with fields not found. I assume this is problem with different Excel versions. I am preprocessing files with a vbscript, but is there another option ?
