Here is an Excel File.
You will find:
- a Named Table (Table1)
- a Named Range (Range1)
The Named Table (Table1) is not available as an option to be loaded in QlikView whereas the Named Range (Range1) is.
TestLoad.xlsx 9.0 K
I think that these Table (ListObject) is no own data-area it's a feature (on a higher level) which will be applied to a data-area and therefore you couldn't access these virtual object directly.
But if you give these Table an additional name you could access it and a normal odbc-load on the sheet or a normale table-load will be work also:
ODBC CONNECT32 TO [DriverForExcel;DBQ=I:\MyPath\TestLoadListObjects.xlsx];
SQL SELECT Country,
SQL SELECT *
FROM `I:\MyPath\TestLoadListObjects2.xlsx`.NameForTable; // with a name for this ListObject
(ooxml, no labels, table is Sheet1);
Thank you for your reply.
Unfortunately, here is a very quick example and the users will have to manage multiple Named Range to apply on top of the Named Table which is not helpful as the table can extend automatically without the range be extended.
I guess you confirmed I have to find another option to deal with that.
The excel name-ranges could be dynamically with an expression like this:
For me these methods worked very well since years - I use it for all my dynamic data-areas, mostly for pivot-tables. Therefore have a further look to the idea - maybe I have made an error by choosing/translating the right function/syntax - in german in function will be called as Bereich.Verschieben().