Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
arngue
Contributor III
Contributor III

Qlik Not Detecting Excel Sheets

Why qlik can detect the entire excel as one unique table? First time happens to me.

I have this excel, within i want to extract first two sheets:

arngue_0-1618390085658.png

 

But when i load it throught qlik sense it only appears one table with the name of the file and the content of that table has nonsense to me:

arngue_1-1618390291957.png

 

here in the image you can se that qlik are setting the columns of the excel without names and it only appears like it has only one sheet ended in column L, but the excel format is not like that.

here is the excel columns format for first two sheets:

arngue_2-1618390733663.png

But when i load it like this:

arngue_3-1618390802979.png

Displays the error of no data to load and i dunno whats happening with this concret excel, copy the content to a new excel is not the desired way to go, even if it whould work, i need to know what is happening.

arngue_4-1618391107779.png

 

 

Did this happened to someone else?

 

 

 

1 Solution

Accepted Solutions
arngue
Contributor III
Contributor III
Author

I am sorry, finally found what happened, between dev and pro was a bug in naming generated excels and the generated content didn't match excel's name, it was another excel whithin the name of the excel i want to load.

Just crazy, i missed updating this post, just closing it now.

View solution in original post

4 Replies
Patricia_Silva
Specialist II
Specialist II

Hello @arngue I am not sure why you are getting this kind of error but from what I can see in the first screenshot, it seems that you have "weird" structure in excel, not like a matrix, is it? Could you please show us a screenshot of how the data is displayed in Excel? Thanks 😊

Help users find answers! Don't forget to mark a correct resolution 🙂
arngue
Contributor III
Contributor III
Author

Hi Patricia,

I have already posted an image of the heading and first row of the first two sheets, the datarows are not entirely shown as is confidencial information, i know you want to try reproduce the error, but without giving you the same excel file its quite a bit impossible.

I am asking if someone had similar issue that can help me finding the problem origin.

And yes, in qlik sense is showing a weird structure that i dunno why is comming up.

May be affected by external excel references? That file is a copy of a shared excel file.

marcus_sommer
MVP & Luminary
MVP & Luminary

Just give it a trial to open the file directly in Excel (not with online) and store it within another copy and then try to load from there.

- Marcus

arngue
Contributor III
Contributor III
Author

I am sorry, finally found what happened, between dev and pro was a bug in naming generated excels and the generated content didn't match excel's name, it was another excel whithin the name of the excel i want to load.

Just crazy, i missed updating this post, just closing it now.