Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Why I'm getting this error, first time I've seen it...
Error: File extdata.cpp, Line 2897
CRM_EncuestaSAU:
LOAD * FROM
[..\Fonts\Excel\EnquestasSAU\CollectorList.xlsx]
(ooxml, no labels, table is Sheet)
Here is my load code
LOAD * FROM
[..\Fonts\Excel\EnquestasSAU\CollectorList.xlsx]
(ooxml, no labels, table is Sheet);
In my case the excel xlsx was generated from a source that can export with xlsx and xls, if i export it with xls or i save the xlsx as xls work, so it's a qlikview bug...
Check that your file really is an Excel xlsx file and not some file that only has a .xlsx extension, but is really something totally different. Try opening it with Excel to make sure it's not corrupt. If you can open then then save it explicitly as an ooxml file with an .xlsx extension.
In my case the excel xlsx was generated from a source that can export with xlsx and xls, if i export it with xls or i save the xlsx as xls work, so it's a qlikview bug...
No it's not a Qlikview bug. You are the one that is specifying the wrong data format.
Ok, could be. But my bet is that the application that exports it as xlsx doesn't do it properly and creates an xlsx file that does not conform 100% to the ooxml specification. Feel free to open an issue with qlik support.