Import a set of properties and values by excel to Dynamo

Good afternoon,

I’m going to tell you about a problem I have with a Dynamo routine, let’s see if you can help me find a solution.

The idea is to create two routines to extract and import the property sets, the properties and their values ​​into an Excel. This way the values ​​could be added more quickly.

I have created 2 routines:

  1. CV_CIVIL3D_01_EXTRAERPSET.dyn - This routine exports the property sets, previously inserted in the model (Quick and easy procedure in Civil 3D when they have already been created from previous projects), to an Excel file. The columns they get are:
    HANDLE
    SET PROPERTY
    PROPERTIES
    VALUES

  2. CV_CIVIL3D_02_DEVOLVERPSET.dyn - Once the values ​​of the properties have been filled in in Excel and the HANDLE column has been modified to match the number of rows in the rest of the columns, this routine would be started to modify the values ​​of the parameters in Civil 3D. I show the routine.

I can’t get this routine to work properly. I have managed to insert each column of the Excel in Dynamo and read it as a string, but the last node gives me problems and does not insert the values ​​of the VALUES column.

Can you find any solution to this that is not Python, since I don’t handle it at all?

I apologize for my English,

Thanks in advance,

Cheers!!

Hi, can you post an image of the excel file, or share the file ?

I had a problem with that node for a graph. Even left it in the graph with a note for futer users/reference :

image

For some reason putting in the property name as a string didn’t work. The value wasn’t updated.
What I did was getting the property name directly from the object, it is also a string but by doing that it has always worked in my tests :