Warning message when combining a Excel list and Revit views list

Lists-Logic
,
1

Hi There,

I’ve not posted on here before and am new to Dynamo.

I have been trying to create viewports on a sheet set using an Excel spreadsheet and keep getting this error message -
*Warning: List.GetItemAtIndex operation failed. *
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
Here’s an image of the problem -

Capture error message
Capture error message1159×700 114 KB

Thanks in advance for any help, I am using Revit 2019 and Dynamo 1.3

2

Hi and welcome, I can see you have more than one problem in your graph, try to avoid null values coming from excel, you do not need the list.create node, and for the error you are getting, I guess the 2 lists must match in count, you have one with 18 items, and the other with 35 items…If you can post/ share your whole snapshot/ script, maybe we can help you more achieve what you are after.

3

Thanks tradelie,

I removed the list.create node and it is working now. I’m not sure why the nul values are coming into Dynamo as they are blank cells in Excel, but I think I know how to remove them.

Thanks again

1 Like
4

@K.Adams7N3LKP ,

You are getting those null-values because that is the way the Excel Import node handles empty cells.