Read “dynamic range” from excel file with a “dynamic name” for the first sheet

Ha, yea that worked. I’ll check this out in a bit.

The only thing is Ill want to read not “sheet1” but rather (0). Since the sheet name always changes name as well (and there is always only 1 sheet). So I am hoping your use case here works, but I create a variable for sheet(0) and then read that.

The image shows the "Read Range" configuration window in an Excel context, with options to include headers and only visible rows, saving the data to a variable named "dt". (Captioned by AI)