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.
The basic process:
- Read CSV File
- Split the values by ‘,’
- Flip the data structure so that each column becomes a branch
- Extract the branch you want
- Shift the list by 1 to remove the header