Dynamo BIM – Sheets to/from Excel

The client had the following scenario – renaming a large number of sheets. The obvious choice was to use Excel. So we needed two Graphs, one for writing to Excel, one for reading back.

Writing to Excel was pretty straightforward:

writetoexcel

Note the Archi-Lab Get Built In Parameter node – this ensures that we are language independent

The result is a spreadsheet with 5 columns – Element Id, original Sheet Number, original Sheet Name, new Sheet Number and new Sheet Name. The last two can be changed to new values.

e1

Now lets change some sheet names and numbers

e2

Reading from Excel was a bit tricky

readfromexcel

Here we have to use the Set Builtin Parameter method provided by Archi-Lab; Set Parameter by Name would not work for Sheet Numbers.

And the result…

res

 

 

About LRCZ

Platform for multiple talents
This entry was posted in Uncategorized. Bookmark the permalink.

1 Response to Dynamo BIM – Sheets to/from Excel

  1. rob says:

    Can you attach the Dynamo scripts? Thanks

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s