Livingroomcraftz

LRCZ Blog

Just another WordPress.com site

Propaganda

September 15, 2019

Another very useless title for a blogpost but – alas – nothing better came to mind so here we go.

And it has been a while since our last post – but it was a mildly crazy year so far.

Topic of the day is – collect elements in Revit using Dynamo, take one parameter and write it to Excel on Office 365. Then edit the sheet online. Then suck the altered data back.

Numero uno – the Dynamo graph to write the data to Excel:

Capture

Script available here.

The file:

Noname.png

The idea is to write all parameter values for “Offset” to Excel for online editing. Here we go:

Noname.png

Now we can edit this file in a browser:

Noname.png

This script will suck the values back in:

Capture

Link to script here.

Video available here.

And life is good.

 

Posted in: Uncategorized