Setting Excel cell to bold?

Packages
1

I’m attempting to use Bumblebee for this. So far, this is not working. I don’t quite see the way to do it from the Primer at https://konradsobon.gitbooks.io/bumblebee-primer/content/220_text_style.html

Please advise.

Screen Shot 01-19-16 at 02.06 PM
Screen-Shot-01-19-16-at-02.06-PM.png1231×900 57.7 KB

2

The text style node is missing inputs.

3

Is there a code block that is just neutral (do not change) for all of the other inputs?

4

object.identity? i think it just passes data through it and doesn’t change it.

5

I couldn’t get it to work with either Live Write Excel or Write Excel. Are there any full working examples to see?

format 3
format-3.png1490×822 102 KB

 

6

Eric,

This graph works for me. I think you have to feed the text style into the graphics style and then into the BB style and then Format Excel. I think BB data is just for the raw data.

 

Bumble Bee
Bumble-Bee.jpg1311×686 116 KB

1 Like
7

I was way off. Thanks to your image, I got it to work.

Strange thing was I had to run it once with “RunIt” = False, then run it again with “RunIt” = True for it to work. What is that about?

format 4
format-4.png1504×812 80.4 KB

8

Eric,

That’s because of how Python nodes are treated by Dynamo. It tries to save resources by not re-running all of the nodes all the time, so it checks if any of the inputs have changed for each node, and then tags them as “dirty”. Only these nodes are being refreshed. That’s why Python nodes require you to toggle to boolean to True, run it, and then toggle it to false and run again. That’s to tell Dynamo, that you want to re-run it.

Tim,

I had no idea, but you seem to have mastered Bumblebee. I would like to hear your comments about it. Are there any glaring issues? Things that you are missing and would like to be fixed? Please post to GitHub.