topic Re: Load xlsx/ooxml sheet n in QlikView

Load xlsx/ooxml sheet n

pjn123pjn123 — Thu, 15 Feb 2018 14:39:15 GMT

Good day

I need to load the 4th sheet in a certain XLSX (ooxml) file.

The name will not always be known but it will always be the 4th sheet.

If it was a XLS (biff) file it would be easy:

(biff, embedded labels, header is 10 lines, table is @4)

But this does not work with ooxml.

Is there a way to load the 4th sheet without re-saving the source files?

Thanks!

Re: Load xlsx/ooxml sheet n

Miguel_Angel_Baeyens — Thu, 15 Feb 2018 15:13:06 GMT

You can use something like this:

How to load EXCEL worksheets and retrieve tab names

Re: Load xlsx/ooxml sheet n

petter — Thu, 15 Feb 2018 15:17:45 GMT

Are you able to have some formula added to the first sheet always? Then you can use some formula functions in Excel to let Excel give you the name of the fourth sheet.

If you follow this approach you first have to read that special formula cells and then you can load the fourth sheet.

Let me know.... and I will give you the recipe.

Re: Load xlsx/ooxml sheet n

pjn123pjn123 — Thu, 01 Mar 2018 07:42:16 GMT

Thanks for the answers.

It turned out both solutions will work in my case.

I used Petter's solution since one of the sheets always has the same name and on that sheet the name of the period is listed which is always the name of the illusive 4th sheet.

Still think it would be nice if the loading of XLS and XLSX didn't had so many differences and was a bit easier.

Thanks again!