topic Re: Unnable to import excel data due to image object in QlikView

Unnable to import excel data due to image object

MatiasParada — Sat, 16 Nov 2024 18:03:30 GMT

Hello,

I'm am trying to automate a report. Basically it has to read an excel file (.xlsx) and make charts with the data. This excel file is automatically generated by a secondary app wich besides the usable data, inserts (by default) a few rows of creation data along with an image with the company logo.

The problem is that when i try to import the data from the Excel file, with QlikView script file assistant, nothing is read. Preview won't show any data no matter how many header lines i skip. As soon as i tried removing the image manually from the excel file, i was able to import all the data, but manual intervention is what i am trying to avoid in the first place.

I've read some posts and it seems that you can treat the image as an object, i believe this shoud allow me to somehow grab it and delete it before trying to read the data.

I would appreciate any ideas or help with this problem.

Screenshot attached showing file assistant not loading data.

Re: Unnable to import excel data due to image object

rubenmarin — Sun, 27 Sep 2020 08:16:53 GMT

Hi Matias,

Hard to say withut the excel to make test, can you upload a dummy excel with the logo (or another image to simulate it) and with some dummy data?

I've loaded excels with logos so it has to be somethig with this particular excel and how the logo/data is inserted

Re: Unnable to import excel data due to image object

MatiasParada — Mon, 28 Sep 2020 21:25:29 GMT

Hello Ruben,

Thank you for your reply, i have added "Example File" to the post, with the original image and the data format (w/ edited text).

Re: Unnable to import excel data due to image object

marcus_sommer — Tue, 29 Sep 2020 12:43:49 GMT

For me it worked like it should - within the file-wizard and also after loading the data:

LOAD column1, column2, column3
FROM [Example File.xlsx] (ooxml, embedded labels, header is 7 lines, table is [Tabular Reports]);

Just try it again.

- Marcus

Re: Unnable to import excel data due to image object

MatiasParada — Tue, 29 Sep 2020 15:15:39 GMT

Hello Marcus,

Indeed it works with this file, i had not tried importing an edited file without removing the image.

I just tried editing a single line (not the image) on a fresh file and then saving it... it works.

Then i tried saving a fresh file without changing anything and it worked as well.

So it might have to do with the way the data is inserted into the file, like Ruben said.