How to dynamically read excel sheet

@emshihab not entirely sure if this is of any help but I thought about Excel and index of sheets and toyed around with openpyxl. There you can extract the explicit index of a file. Maybe you could do the same by just importing all sheets via Excel node and see their sorting.

As far as I understand your case you will have to either have the date in the name of the sheet (would there be a Excel file per month or would you have to take care of last and first date of month also) or you will have some indication within the data itself.

All being said this seems not an ideal way to safely transfer data so you might try to work on that part too. Maybe name the sheets with an explicit timestamp “2021-12-24” that would be easier to handle.

1 Like