Split data from Excel File

Grasshopper
1

Hi everyone

I have an excel spreadsheet with two columns. In the first cell is a text and in the second cell of the same row is a number.

A I 10
A I 20
B I 20
B I 30

My goal is to take the values in the first column and to use the text to split the list. Because the amount of values will grow, i can not split by index.
With the number i will then create rectangles.

Do you have any recommendation how to do that?

Thanks

2

I like this plugin for excel
https://www.food4rhino.com/app/npoiexcel

you might have to be a little more specific on “take the values in the first column and to use the text to split the list”

image
image782×433 23.6 KB

3

For the second part, Pancake’s Categorize Data may be useful.

image

4

forum
forum1314×747 84.1 KB

Thx guys… I want to create rows with rectangles. All “A” rectangles in a row, All “B” rectangles in a row. So i want to split the list in A, B and in the future in C, D etc.

5

looks like you’ve got it, you can use the pancake component to get your branching or the more traditional CSET

image
image1586×630 88.7 KB

6

here is a continuation per your additional questions

image
image1632×560 182 KB

7

Awesome thanks… I made this. Far from perfect :slight_smile:

REC
REC1648×606 112 KB

8

I will try yours!

9

ideally you wouldn’t flatten the branches, keeping the data structure intact as long as possible.

10

Sure yes. Thanks for the help.
Your script doesn’t work for me… The rectangles must have the exact same size as from the list item output…