Adopted Code Script

excel

#1

I am creating a key schedule using the attached script and an excel file. The script works fine but I would like to be able to utilize a pull down list of the sheets in the excel file to allow users to bring in that jurisdictions data (or better yet get the project address from the revit project information parameter so the user just runs the script and it reads the data and imports only that sheets data). When I hook up the 2 nodes that gather the sheet list to create the list it only shows the first 2 sheets? So I am stuck. Thoughts


#2

Can you show a preview of the GetExcelFileInfo node? If you’re not getting all the worksheets in the file there might be something wrong with thee excel file itself.


#3


Its a very simple excel file with tabs for jurisdictions.


#4

@agray Please share your dyn and Excel file


#5

ADOPTED CODES.xlsx (16.6 KB)


#6

ADOPTED CODES.dyn (34.8 KB)


#7

I have the list option working. Now I just need to pull the project location from the sheet title parameter.


#8

@agray