Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
mario_romero
Partner - Contributor
Partner - Contributor

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

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.

0 Replies