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 ?
If your excels are in opened in edit mode and then QV cannot load such file . Excel version might has impact in loading the file unless if it corrupted, and follow the steps mentioned by anjali12gupta you should be able to load . If your still facing any issues please share the sample excel file.
I don't really understand. If the file does not have 12 header lines, then adjust that parameter. It will look for field names as column titles in the first row after it has skipped the header lines. It seems that the field names / column titles are not in that row.
There is not normally a need to first open and save the file. What is your vbscript doing?
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Interesting, same problem. If I open the file I receive the wizard does not find column names at all when specifying 12 lines of heading. If I firstly open the file in excel and save it, then the wizard works as expected.
The vbscript is just opening and saving the file which solves the problem. I suspect that the file I receive is not entirely compatible with QV, but opening in and saving it in Excel locally seems to correct whatever the problem is.
