This exercise illustrates how data can be streamed from a Grasshopper panel to

 

e.g., an Excel spreadsheet using a .csv (comma separated values) file by right- clicking onto the panel. Here we extract the corner point coordinates of a set of sub-surfaces of a main surface.

In Grasshopper:

1.Get the vertex coordinates of all sub-surfaces

2.Convert to string (=text), remove “{“and remove & replace the “}” with a “,”

3.Reshuffle the data so that each line in the panel has all coordinates combined with values separated by a comma.

4.Right-click and Stream Contents to a .csv file

 

In Excel:

5.Open a new spreadsheet and click on the first cell where you want to insert your table

6.Data > Get External Data > From text: select your .csv file

7.Set the data delimiters to comma

 

Update:

8.Re-stream the data from Grasshopper

9.Data > Refresh All in Excel

 

Spreadsheets and data exportation allow for a direct communication with various other softwares and fabrication tools. Several plugins provide more advanced functionality to allow communication between Grasshopper, Excel, and other software packages.