6.2.03. Spreadsheet Data Streaming

BSL_GH_056_M

Loading

Date published: August 23, 2022

DESCRIPTION 

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.
 
PROCEDURE
 
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.

This exercise is using Grasshopper version 1.0.0007 

Software

Rhino 

Plugins

course files

Spreadsheet Data Streamer.zip

1.22 MB | 1909 downloads