Create sheets By Name, Number, Title Block


#1

I was importing from Excel file to create automatically sheets by Name, Number, Title Block. and everything goes well, till the last node, it’s give me “Function” error.

could anyone help me what I have missed, see below Dynamo Diagram


#2

Try with a boolean toggle connected to Refresh, if it doesn’t work you probably need to use List.OfRepeatedItem and Count to get the same amount of Titleblock Types as the other inputs (in your case 27)


#3

I have done the below and works well, thanks man.

However the other options ( Sheet.ByNameNumberTitleBlockAndViews) still not solve, you could try and help me how we can do that?


#4

It works the same way but you additionally need a list of Views, those you want to place in each sheet.


#5

I’m still missing something !,see below, any idea ?

01


#6

It is because you are feeding the “View” input a string from Excel. You will need to get a list of all views and filter out based on your view title. The element you feed the node needs to have the GREEN text at the end to work for what you are trying to do.