How ignore some sheet?

[vchuprina]

I received xls files, and these files have many sheets. Last sheet in file is incorrect. How ignore this sheet?

[jyothish8807]

Hi,

How are you loading all the sheet of workbook?

Regards

KC

[jyothish8807]

Hi,

go through this:

http://community.qlik.com/docs/DOC-4452

In this simply ignore the last sheet from the loop and try to number your sheets as 1,2,3.....

Regards

KC

[vchuprina]

I use following loop

FOR j=0 TO NoOfRows('tables')-1

.

.

.

.

Next j

[jyothish8807]

Hi,

Simply make it :

FOR j=0 TO NoOfRows('tables')-2

.

.

.

.

Next j

So it will ignore the last sheet. give it a try.

Regards

KC