Load a named table from Excel

[agaetisproject]

I am trying to load a named table from Excel but can't figure out the script to achieve this.

Can someone help me?

The named Table is called Personnel and appears on Sheet1

LOAD *

FROM [lib://FIlename.xlsx]

(ooxml, embedded labels, table is Personnel);

Thanks a lot in advance.

[sunny_talwar]

Is this Qlik Sense or QlikView?

May be try this:

Personnel:

LOAD *

FROM [lib://FIlename.xlsx]

(ooxml, embedded labels, table is Sheet1);

[MindaugasBacius]

If you have few tables in one excel sheet like in picture below:

While loading data you should take Transformation steps first:

[Gysbert_Wassenaar]

Usually you create a connection to a file system folder and add it to your library and your file exists in that folder:

LOAD *

FROM [lib://MyFolder/Filename.xlsx]

(ooxml, embedded labels, table is Personnel);

Check that your created a connection in your library first. Simply typing lib://something doesn't create a connection in your library.

Alternatively use the Data Manager to load the data from the excel file. You'll be walked through a few screens and the connection will be made for you and the data loaded. You should see the tables, including the named tables, in excel on the third screen:

[agaetisproject]

Thank you. It seems I wasn't clear. My issue is not how to load a table but how to load a named table.

In Excel, you can create an object Table and give it a name. From the name manager, you can reuse the object and its column. I wan wondering whether Qlikview can 'read' the named objects of a workbook, like a table or a named range.

Is that clearer?

[richard_chilvers]

I always struggle with formatting the LOAD for an Excel file.

Have you tried using the <Table Files> button, to activate the Wizard ?

[Gysbert_Wassenaar]

I wan wondering whether Qlikview can 'read' the named objects of a workbook, like a table or a named range.

Is that clearer?

Both Qlikview and Qlik Sense have no problems loading data from tables defined as Named Ranges in Excel.