topic Re: Can't load Excel File in Connectivity & Data Prep

Can't load Excel File

Thu, 18 Sep 2014 10:39:16 GMT

I've tried several times loading an excel file in Qlik Sense, but I can't.

It appear the screen when you have to select the fields, but the loading image (right/down) continues working. I've been waiting (this time) 30 minutes and, although the loading image is moving, the screen seems to be blocked

The excel file is an xlsx. of 1.6 MB, with 6 sheets. The first sheet have 3000 rows, and 67 columns. The others are small.

Re: Can't load Excel File

Michael_Tarallo — Thu, 18 Sep 2014 12:33:28 GMT

Hi Jose - do you have any blank rows - at the top of the excel file?

Can you send a screen-shot - of the first tab in the .xlsx file - please blur out any sensitive information.

Mike

Re: Can't load Excel File

Giuseppe_Novello — Thu, 18 Sep 2014 12:54:45 GMT

Jose,

When you select the other table can you see data? or only the "farmacias" table has issues?

Re: Can't load Excel File

fkeuroglian — Thu, 18 Sep 2014 14:55:59 GMT

Jose podes enviar el excel para probarlo?

las otras pestañas del excel te muestra informacion en qlik sense?

slds, Fernando

Re: Can't load Excel File

Thu, 18 Sep 2014 15:34:38 GMT

I've deleted all the sheets but the first one, but still can't load it.

Why in the left side appears a lot of tables if I only have one sheet now?

I can load the same file in QlikView without any problems

Re: Can't load Excel File

Thu, 18 Sep 2014 15:34:49 GMT

Can't send the excel, as it has sensitive data.

Re: Can't load Excel File

Thu, 18 Sep 2014 15:35:14 GMT

The programam stops working, so I can't select any other tables.

Re: Can't load Excel File

Thu, 18 Sep 2014 15:36:23 GMT

There are any rows.

Can't send the excel, as it has sensitive data.

I've modified the data, but still not working:

Re: Can't load Excel File

pbr — Fri, 19 Sep 2014 14:37:20 GMT

What version of Sense are you using?

Would you be able to get us a version of an Excel Spreadsheet with no sensitive data that replicates the issue?

You should be able to load that Excel file into QlikView, make a table, then scramble the data (Settings -Document Settings - Scrambling Tab), and then export that back out. You can test this new scrambled file in Sense and if that works, there might be something in the data that's causing the issue.

Re: Can't load Excel File

Giuseppe_Novello — Fri, 19 Sep 2014 14:43:22 GMT

Jose,

Have you try to do a simple excel sheet and use that? Also, any chance the current excel sheet has weird/special characters? Have you try to make a copy of your current excel file and try the "elimination process", by removing content on the excel sheet until you notice that it works, and try the last thing you removed and see if that breaks it.

Gio

Re: Can't load Excel File

Mon, 22 Sep 2014 08:38:33 GMT

I'm using version 0.96.0

I've tried deleting most of the rows, and it works now. I just left 2 rows and the header.

Also, I've load the Excel in Qlikview, export it (with and without scrambling), and then I'm able to load it in QlikSense.

So I guess it is the Excel file that may have some weird characters, but the main problem I have is that the Excel file is updated daily by third parties, so I have no control in data values.

Anyway, thank you very much!

Re: Can't load Excel File

Fanyin2019 — Wed, 18 Dec 2019 22:14:35 GMT

What problems could be? I do not have QlikView and I could not upload excel, not sure what the problems are.

Thx,