Specify sheet name in Dynamic Input for reading .xlsx file

srk0609

I'm trying to bring top 3 Excel files based on date in file name. Each excel file has multiple sheets. There is sheet with name 'A' in all 3 excel files I want read data in sheet A of all 3 files but getting error 'No sheet specified, you must specify a sheet' in Dynamic Input. Can someone help?

DataNath

Hey @srk0609, the [FullPath] field from the directory output stops at the filename and therefore doesn't contain the filename. Try making a new calculated field using the following expression, and feed that into the Dynamic Input instead:

[FullPath]+'|||'+'A'