Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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