Discussion Board for collaboration on QlikView Scripting.
I received xls files, and these files have many sheets. Last sheet in file is incorrect. How ignore this sheet?
How are you loading all the sheet of workbook?
go through this:
In this simply ignore the last sheet from the loop and try to number your sheets as 1,2,3.....
I use following loop
FOR j=0 TO NoOfRows('tables')-1
Simply make it :
FOR j=0 TO NoOfRows('tables')-2
So it will ignore the last sheet. give it a try.