Exporting shape images to excel

[luis.brionesalonso]

Hi there,

I’ve been having some problems with exporting rebar schedules to excel for some time now.
Getting the data from the schedules and exporting it works fine, with the exception of exporting the shape image of the rebar shapes as an image. Right now it exports it as text.

Does anybody know of a way to export shape or type images to excel?

[Mark.Ackerley]

Hey,

Maybe try the bumblebee package? It might be that you can get this to work?

Embed Image to excel file

This node sure as hell was experimental and has its quirks: [image] Notice how the file path is passed through List.Create node. It has to be a list of file paths. Not a single file path. Also, the Origin input has to be a list, that matches the list of file paths. So if you have one file path on that list, just put one origin on a list {"A1"}. Finally the image names has to be a list also, and it also has to match the other two lists. Again, if its just one name, then you can do what I did. C…

Hope that helps,

Mark

[luis.brionesalonso]

Thank you for the response. I came across that node some time ago but could not for the life of me get it to work. It’s probably just a lack of experience holding me back so should have another go at it when I can.

[Mark.Ackerley]

I had a quick look…

So, bumblebee is off looking for this file?

in packages\BumbleBee\extra

This file goes to look for protogeometry, to do this, it shortens the Dynamo version… You can open it with notepad and see that…

dynamoversion = str(dynamo.GetName().Version)[:3]

Unfortunately this outputs ‘2.0’ for me… whereas the dynamo team have named the actual folder ‘2’
so everything fails.

If you amend the line in that file to
dynamoversion = str(dynamo.GetName().Version)[:3][0]

It returns ‘2’ and works (at least for me, for this version)

Hopefully that helps.

Cheers,

Mark

[luis.brionesalonso]

Thank you for your detailed response. I tried looking for the line in the file you mentioned but can’t find it, ctrl+F doesn’t find it either.

I tried creating a seperate dynamo to just simply embed the image and even though there are no errors shown and the output for the mebed image node is succes, it still does not embed the image into the specified excel file. (just an empty cell)

[Mark.Ackerley]

Hey, the line you’re looking for is in:

packages\BumbleBee\extra\Bumblebee.py

Could you confirm with a screen grab that that is where you are looking?

Thanks,

Mark

[luis.brionesalonso]

Hi,

This is the file I’m looking in. I scanned it three times manually and still didn’t find it so I really hope it’s not just me being stupid

[Mark.Ackerley]

For me it’s near the top

Maybe it changed in your version?

[luis.brionesalonso]

Huh, really strange. Legitimately not there in my version

[Mark.Ackerley]

I popped over to Konrad’s github, copied the same code as you have over to my bumblebee.py file and the graph ran…

I think you might have to raise it with him, sorry…

Mark

Edit: you do have an open Excel file when you run it right?

[luis.brionesalonso]

I have the excel file open, but I’m running it from Dynamo for Revit. Maybe the problem is that I need to use sandbox or something?

[Mark.Ackerley]

Mine’s fine in Dynamo Revit…

[luis.brionesalonso]

Strange, I’ll try to take it up with Konrad as you suggested. Thanks anyway for all the effort and help!

[gerbenKAG9F]

Did someone already got this to work?

[simon_murphy1]

Create a family library document (export Excel with PreviewImage)

Hi I am trying to create to a document like the image below. It has a preview image of the family in the first column. The type name in the second column. And the file path of the family document in the third column. I have managed to get all the pieces required to build the family library document. The difficult part is exporting this information to a suitable place. The image below uses a Bumblebee package workflow to embed the images in the Excel document but it is not stable and the images …