Qlikview - Load named table from excel file

[maxime66]

Hi qlikers,

I would like to Load a named table from an excel file, is that possible ?

something like this (where "Table_sales" is the name of table in this excel file)

LOAD ,
Column1,
Column2
FROM
[C:\Users\Desktop\workbook.xlsx]
(ooxml, embedded labels, table is Sheet1\Table_sales);

[Anil_Babu_Samineni]

Check this https://community.qlik.com/t5/New-to-QlikView/loading-all-sheets-data-from-excel/td-p/673784

[maxime66]

Thanks for the link Anil,

but my goal is to point a specific Table in a sheet

and not just rows and column in a sheet.

[Brett_Bleess]

I would recommend using the Wizard in the QlikView Script Editor to walk through the load from the Excel file, which should give you the correct connect to statement and script statements to pull just that data from the sheet in question, that should be the easiest way to go about this.  

The following Help link may be of some use on this one too:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/LoadData/how-to...

There is info regarding Named Areas in that link, just FYI.

Regards,
Brett