topic Re: How ignore empty sheet in xls files? in QlikView

How ignore empty sheet in xls files?

vchuprina — Thu, 26 Feb 2015 17:06:21 GMT

Last sheet in files is empty, and when I run script i receive following error message:

"Cannot locate table in BIFF file."

Part of script:

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

LET SheetName = if(right(peek('TABLE_NAME',j,'tables'),14)='FilterDatabase',

subfield(purgechar(purgechar(purgechar(subfield(peek('TABLE_NAME',j,'tables'),'$_',1), chr(39)),'$'),'_'), 'FilterDatabase', 1),

purgechar(purgechar(purgechar(peek('TABLE_NAME',j,'tables'), chr(39)),'$'),'_') );

LOAD *

next j;

Gysbert_Wassenaar — Thu, 26 Feb 2015 17:55:28 GMT

Try setting the ErrorMode to 0 for the loop.

SET ErrorMode = 0;

// For Next loop

For ...

.....

SET ErrorMode =1;

vchuprina — Thu, 26 Feb 2015 18:25:29 GMT

I try this, script running without error message, but data from file doesn't load

Gysbert_Wassenaar — Thu, 26 Feb 2015 19:40:23 GMT

Works for me. See attached files.

vchuprina — Thu, 26 Feb 2015 21:12:35 GMT

Thank you Gysbert. It works fine when sheets in source file are numerated:

Sheet1 Sheet2 .... SheetN,

but doesn't work when sheet name without number at the end.

As example names of sheets in my files:

District Comp Status Sheet1(empty).

Maybe you could advise me another way to disregard Sheet1