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
@umairah
Do you have a sampel data?
We can get the Sheet Name as list then do something from there.
Hi @Qiu & @apathetichell
Sorry I will put sample file for you to test.
Regards,
Umairah
@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:
@ArtApa- yup - I see you added a step I didn't have which gets around my potential problem (ie... I was running off of sheet name and the original file name) whereas you have intelligently created a full path with a specific sheet which gets around that silliness. IRL I'd probably use a batch macro but I was more concerned with replicating a date compatable syntax for the worksheets than making a batch macro on this one...