AnsweredAssumed Answered

Where are my worksheets in my excel file? And what parameter data type are they?

Question asked by on Nov 14, 2018
Latest reply on Nov 15, 2018 by

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!