Dynamic Input error : sheetname does not match a sheet or named range in file....

[Molson]

Hello,

I have a workflow that is pulling in all files where the name starts with a specific set work word (MasterAccountDetails*.xlsx), the filtering to the last file created. I add the sheet name to the FullPath.  Then I am trying to read in the file with they Dynamic Input tool.

 

I am getting an error 'MasterAccountDetails does not match a sheet or named range in MasterAccountDetails2024-10-08_09-06-16.xlsx or the file is corrupted."' When reading in the template I am using the below settings

 

As you can see it is not showing that there are any sheet, when it obviously is a sheet. What do I need to change to be able to have the Dynamic Input tool read the file?  Any help will be appreciated. 

 

[binuacs]

@Molson Try a different template in the dynamic input tool.

[Molson]

@binuacs I updated the template so there was no date on the file and it now shows the MasterAccountDetails tab, however I am still getting the same error "MasterAccountDetails does not match a sheet or named range in MasterAccountDetails2024-10-08_01-01-01.xlsx or the file is corrupted"

[binuacs]

@Molson I think the file is  MasterAccountDetails2024-10-08_01-01-01.xlsx is corrupted which causing the issue, can you try with a different file saved in the folder and try again

[nagakavyasri]

@Molson Try selecting a sheet name in the dynamic input tool instead of reading list of sheet names.

[Molson]

This happens no matter which file I try and load, there have been 2 different files this morning and both have had the same error.  I don't have an issue opening the files directly, which if corrupted would say so when opening the file. We are downloading the files from a website.

[Molson]

I have tried that and am still getting that error.  It is like it doesn't register the sheet name when I am feeding in the FullPath.

[binuacs · Accepted solution]

@Molson @Can you create an excel file manually with the above sheet name or save as the existing file to a different name and  try again? I’m thinking the excel from the site is not properly reading in Alteryx

[Molson]

I created a file manually with the sheet name or saving the existing file as a different name worked. Thank you for your help.