I am trying to perform analysis on worksheets in a .xlsx file. However, I am unable to access the worksheet. In the ArcGIS Pro catalog, I see my Excel file with a drop-down arrow, but when I click on it, the worksheets do not appear. I am expecting about 16 sheets to drop down, with "$" in the name of each. I don't understand why this is happening.
I tried troubleshooting by copying all the data into a new excel file, with the same number of sheets, with no special formatting. This did not solve any problems, and I don't know what to do.
Also, a related question, what parameter data type is an excel worksheet within a file? I am creating a script tool which is supposed to take an excel file and a worksheet as 2 separate parameters. I know the excel file is a "file" type, but I don't know about the worksheet.
Any help would be greatly appreciated!