Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

vchuprina
New Contributor II

How ignore some sheet?

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

4 Replies
jyothish8807
Honored Contributor II

Re: How ignore some sheet?

Hi,

How are you loading all the sheet of workbook?

Regards

KC

Best Regards,
KC
jyothish8807
Honored Contributor II

Re: How ignore some sheet?

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

Best Regards,
KC
vchuprina
New Contributor II

Re: How ignore some sheet?

I use following loop

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

.

.

.

.

Next j

jyothish8807
Honored Contributor II

Re: How ignore some sheet?

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

Best Regards,
KC
Community Browser