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

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.

dynamic input workflow.jpg

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

Dynamic input setup.jpg

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.

Input

Dynamic Processing

Accepted answers

binu_acs

@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

All comments

binu_acs

@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"

binu_acs

@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.

binu_acs

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703