How to read only the latest sheet in the excel

Hi,

I got an excel file that contain monthly data and every month new sheet will be added to the same excel file that contain data for that particular month.
e.g : JAN 21, FEB 21, MAR 21,....

My situation right now is I want to read only one sheet per month which is the latest month in the excel file. Is there a way to achieve this.. Any help is appreciated.

Regards,

Umairah

Common Use Cases

Dynamic Processing

Preparation

Accepted answers

All comments

Qiu

@umairah
Do you have a sampel data?

We can get the Sheet Name as list then do something from there.

apathetichell

without sample filenames this is pretty hard to do... Here's a sample workflow - but this might not help you at all depending upon how your sheets are named...

choose most recent sheet.yxzp

umairah

Hi @Qiu & @apathetichell

Sorry I will put sample file for you to test.

Regards,
Umairah

MASTER-IB Transaction.xlsx

ArtApa

Hi @umairah - Here is a sample workflow for you:

LatestSheetAA.yxmd

apathetichell

Here's how my workflow would be adapted to your filename specifics... My workflow and requires that each month's sheet has the same schema - if that's not the case the workflow requires a different approach at the end.

choose most recent sheet.yxzp

ArtApa

@apathetichell - You don't need all the Sheets to be in the same schema. You only need the same schema, if you want to stack multiple sheets on top of each other using one Input Data or one Dynamic Input. However, in this scenario you need to read the latest Sheet only. Excel will allow only one Sheet in a file with the same name. That means you can have anything there. I added the following to the sample file:

and it worked well:

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703