Error reading dynamo on excel

Hello,

I wanted to know how you deal with the problem of reading on dynamo,

Explanation of the dynamo:

I create a list on excel
PO1…PO2…PO3…PO11

With dynamo I make a search of this excel list, to have the families associated to this parameter.

Then I display the spaces with the families which have this parameter in an excel column.

My problem, if dynamo search the families containing PO1 in a space, I will also have the spaces of PO11…PO12…PO13…PO14
which is logical because PO1 is inside, I would like it to read the whole parameter before doing something…

Do you have an idea

It would help if you could provide pictures of your excel file and of your current dynamo path/code

1 Like

Yes its better like that @leonard.moelders ^^

Step 1
create list

Step 2
Dynamo code

Step 3
Read my Revit

Step 4
Write on excel
image

Problem in Space 5 i dont have PO1 but i have PO11

Not a video, a picture. Zoom as far in that you can see the input names of the nodes. Open the result preview for every node and then use the screenshot tool from dynamo. You do not need to see all of your code. It will capture the whole workspace by itself:

1 Like

ahh right, thanks I didn’t know @leonard.moelders

The names of the nodes are missing :sweat_smile:

Not the group name, the node names.

1 Like

1 Like

Thank you :slight_smile: I will have a look :slight_smile:

Why doesn’t he do it directly… ^^ sorry I’m struggling but I’ll remember it

I have two goals for this code,

  • to sort the PO in order when he will write on excel,
    NOT like that :
    image

  • not to confuse PO1 and PO11

Just a quick question:

The following list shows what you want, right? Until there everything is correct? I ask because your image above picturing the spaces is so bad, that I can’t read the PO numbers in it :smiley:

yes this list shows me what I want without confusing PO1 and PO11

I didn’t understand this part? “I ask because your image above representing the spaces is so bad I can’t read the command numbers in it :smiley:

The resolution of the picture is not high enough to read the numbers.

This picture:

1 Like

SPACE NAME AND GMAO_2.dyn (85.9 KB)

its better like that ? @leonard.moelders ^^

Can’t see any difference on the picture, but this is what i got:

1 Like

I’m going to try to do what you did and test to see if I can keep up with you

ca you show me , what is hidden here pls
image

@leonard.moelders

and here i can’t see ^^ all
image