Data Load

[evansabres]

I am attempting to load data into Qlikview from an excel file that is from an automated data offload. The data comes through as an excel table (similar to attached) However, because the data is formatted as a table with each column having pre-built filters, Qlikview does not recognize the file and will not load. Is there a method within the script to convert the data file so that it can be brought in correctly?

[rubenmarin1]

Hi Evan, I tried this and the data has been loaded as in excel:

LOAD * FROM

[.\Book1.xlsx]

(ooxml, embedded labels, table is Sheet1);

If you drop the xlsx in QV, this is almost the default script. Maybe there is something different in the real excel file.

[evansabres]

Thank you.