Load xlsx/ooxml sheet n

[pjn123pjn123]

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!

[Miguel_Angel_Baeyens]

You can use something like this:

How to load EXCEL worksheets and retrieve tab names

[petter · Accepted solution]

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.

[pjn123pjn123]

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!