Error (File extdata.cpp, Line 2897) reading a .xlsx document when Qlik does not found the Sheet

mario_romero — Wed, 26 Jul 2017 08:38:00 GMT

Hi all,

I'm trying to modify my script to handle the errors during the load. When I try to load an Excel document with a sheet that does not exist to catch the error, I get an error different that which I supposed.

I expected to get a ScriptError=8 (Table not found) but I have a General Error.

This is my log:

26/07/2017 10:25:28: 0235 PFN_2017:

26/07/2017 10:25:28: 0236 CrossTable (AñoMes_KPI, Valor, 4)

26/07/2017 10:25:28: 0237 LOAD * FROM [..\..\Ficheros_fuente\Consejo\Publico\PFN\Evolucion PFN_2017.XLSX] (ooxml, embedded labels, table is [Resumen] , Header is 3 lines)

26/07/2017 10:25:28: Error: Error: File extdata.cpp, Line 2897

Why this error is a "General error" instead of a "Table not found error"?

Thanks.

topic Error (File extdata.cpp, Line 2897) reading a .xlsx document when Qlik does not found the Sheet in QlikView

Error (File extdata.cpp, Line 2897) reading a .xlsx document when Qlik does not found the Sheet