Add spreadsheet

[#1]

Hi

I have a app where the connection for data is to a SQL db.

Within the app i need one tab which shows data from an excel spreadsheet.

How can i do this?

Thanks

[maleksafa]

what do you mean excatly? because you can load an excel spreadsheet into qlikview very easily and then add a flag when loading from excel that this is coming from excel, and in your tab filter on the excel flag.

[#3]

so I have a QVW where all the data is from a SQL db.  I have a requirement to display the output of a excel file in one tab

[its_anandrjs · Accepted solution]

Load that excel table individually  to the data model like

Ex:-

LOAD

     Country,

     City,

     Total

FROM

[Mapping table.xlsx]

(ooxml, embedded labels, table is Sheet1);