due to issues with csv and txt files I am having to import xlsx files.
Each file is created with a worksheet name
In data factory I use Wildcard Filepath *.xlsx however there is no way seemingly of changing the worksheet name for every file.
So I get this error message
rrorCode=ExcelInvalidSheet,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The worksheet cannot be found by name:'2018-05' or index:'-1' in excel file '2020-09.xlsx'.,Source=Microsoft.DataTransfer.ClientLibrary,'
Can anyone point me to a good way of doing this, so I can either bypass the worksheet name or dynamically change it with every file?