Qlikview reads nothing from an Excel line that is completely blank. It seems to be repeatable. I had a problem with an application that had to count the number of lines and it would not count the blank lines, so I had to put dummy text in a column in those blank lines so the count would be correct. (And I think that was Qlikview V9 or V10)
okay. So I guess I can rely on that.
It's relevant because I document the function and use of every app I make, so I will write to just count the lines above the column_headers, not counting completely blank lines, and to specify that number - there are some input_boxes in my script which has to be run locally anyway.
Thanks a lot!
I'm not sure but I believe this is an expected behavior - to ignore rows without any content. You could try to load the data without labels and extra header or something similar - to see if any option changed this.
By newer excel with xlsx-extension could it be possible to load the file not as excel else as xml-file - have never tried it but it might work. Also could a qdbc sql-load have another behavior: ODBC connection to Excel file.