topic Re: Qlikview - Load named table from excel file in QlikView

Qlikview - Load named table from excel file

maxime66 — Wed, 25 Nov 2020 16:16:04 GMT

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);

Re: Qlikview - Load named table from excel file

Anil_Babu_Samineni — Tue, 10 Dec 2019 12:08:49 GMT

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

Re: Qlikview - Load named table from excel file

maxime66 — Tue, 10 Dec 2019 12:19:07 GMT

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.

Re: Qlikview - Load named table from excel file

Brett_Bleess — Tue, 17 Dec 2019 21:30:11 GMT

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-prepare-excel-files-for-loading.htm

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

Regards,
Brett