AnsweredAssumed Answered

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

Question asked by Higham.chr@gmail.com on Nov 14, 2018
Latest reply on Nov 15, 2018 by Higham.chr@gmail.com

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!

Attachments

Outcomes