Grasshopper – Reading Values from Excel: Part 1



This is a two part tutorial on how to read values from Excel into Grasshopper.

Part 1 will describe a technique for reading excel data through a CSV file and extracting the various values into data lists for you to work with.
Part 2 will apply this to a parametric bench example that has variables to control several profiles.

I have attached a grasshopper file and a CSV file for this demonstration. In the second part, I will demonstrate a method of having a user friendly interface in Excel.

Download source files.

The basic process:

  1. Read CSV File
  2. Split the values by ‘,’
  3. Flip the data structure so that each column becomes a branch
  4. Extract the branch you want
  5. Shift the list by 1 to remove the header

~ by admin on March 20, 2011.