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.