Grids from Excel

If you have a Grasshopper document and you want to transfer geometry to Revit, one way to do this is via Excel. Of course there are other plug-ins available, such as Rhynamo, Mantis Shrimp, Grevit, etc., which can also transfer data. However, Excel is ubiquitous – it’s easy and simple to use, yet so powerful.

This tutorial explores how you can translate grids from Rhino to Revit via Excel. The first stage is to generate some grids within Rhino/Grasshopper. The example below uses a simple Grasshopper script to generate the grids as well as the numbering sequence. The start and end points of the grids, along with their mark value, are exported to Excel via the Lunchbox ‘ExcelWrite’ component. Note that for Lunchbox to be able to write to Excel, Excel first needs to be open.

Grasshopper_GridExcel

Once exported, the Excel spreadsheet will look something like this. Note that to avoid problems later, I’ve not exported the headings.

Excel_Grids

We can now use Dynamo to import this data and create native Revit grids that are numbered accordingly.  Using the ‘Grids.FromExcel’ node from the BVN package we just need to state which worksheet and columns to read.

Dynamo_Grid

If there are already grids in your project you may encounter an error saying, “the name entered is already in use. Enter a unique name.” The easiest way to fix this is to ensure there are no grids in your project before running the Dynamo script.

Revit_Grid

The benefit of using the above method over say a simple *dwg export and using the pick line command, is that not only is geometry being transferred, but the data as well. Thereby maintaining the ‘intelligence’ of the original Grasshopper script.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: