4 Replies Latest reply: Feb 26, 2015 4:12 PM by Виталий Чуприна RSS

    How ignore empty sheet in xls files?

    Виталий Чуприна

      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;