Excel input to MLeader-Table

I guess the best approach should convert the data coming fom Excel into OLE… but I do not know if in Dynamo exists nodes for OLE features…

For problem 1: AutoCAD is smart in that it clears spaces without another character on the end. Append a zero with space (search your windows character map for this) to the end of each string and see if that fixes things. :slight_smile:

See this

UpdateTitleblock

Think Can you remove the blanks?
By drawing a rectangle around the text using 4 lines and connecting them to the text
long way
But if you use the block with attributes butter , it is easier

Here’s an example using a general note label.

No, these are not implemented at the moment.

These nodes are available in Camber v2.0.0.

An other way
Block + texts linked to the block

Q10

1 Like

I see your point @hosneyalaa but the distribution of the colors within the “table” is not always the same. Sometimes the red cell will be the last one, sometimes will be the first one… If you modify the Point Label Style, all the CogoPoint visualization will be modified.

on what basis
Colors are distributed
Why is it changing

I have plenty of combinations:

For that reason, I would need to access the values of the tables and modify the colors.

You need node to change color according to conditions
if there is no
You need Python script

I will have a look at it tomorrow first thing in the morning @hosneyalaa but I think that that is not going to work with CogoPoints Point Label Style. It will work, for instance, for General notes as @zachri.jensen shows here: Excel input to MLeader-Table - #26 by mzjensen

Thanks,

Yes, you are right
I didn’t notice that

This looks like a fun nut to crack, I got close with blocks. There’s a lot of steps here but the focus seems to be on what mechanism can we use to change the color of individual text and keep them organized. I attempted the block route too and I basically made a separate block for every cell and was using Dynamo to check “number” blocks for the value and then move those blocks to a layer based on the value and by having the text attribute set to bylayer this will change the text color. The part that’s slowing me down is trying to organize all the blocks. I tried to see if I could nest the blocks but I can’t find a way to manipulate the nested block references and found a way to manipulate the block definition lol.

1 Like

It seems an easy task but actually, it does not… haha. I guess this is more complex than other Dynamo tasks as this is not related to design steps and it is with capabilities of the software (software development).

@KirkWM , with anything you achieve, please, could you share your DWG with the blocks inside and the DYN?

Thank you so much,