See screenshot of weird "DS_INTERNAL...." sheets that don't actually exist when I open the excel file. My issue is the file name changes often so I have the input tool set to "*.xlsx", and normally I dont need to specify the sheet name because its only one sheet. But now, I'm getting errors requiring me to select "sheet1", even though it is the only sheet. Anyone know what is happening and how I can prevent this?
That toggle displays both sheets and named ranges/tables. Either they are hidden tabs or named ranges/excel tables.
@jmer
If you have it in the user interface it is means that it coming from the excel file. Alteryx does not add sheets that are not there. So they are hidden, If you know that you need always Sheet1, you can automate it in the following way, get the guys to select the option List of Sheet Names. In your WF replace ,List of Sheet Names> with File Name and then Get the unneeded sheets filter out and you can open the file now.