I’m trying to create a way to load relatively large amount of data from excel to grasshopper and then manipulate the data with a preset amount of panels.
So my idea is that I would store all the data into one panel and then load part of the data to different panels which are connected to some other functions that transform the data into geometry. From this I could change part of the data from my preset amount of panels and then store it back to the data tree where it could then be later exported back to excel.
My idea is to change which part of the data is displayed with a drop-down list that takes the “header” of each data chunk.
I started doing this in a vba component in grasshopper but encountered one problem by far: I haven’t been able to update the panel values. I’ve used panel.addvolatiledata() method. It seems to change the value in the panel but does not update the downstream components.
Any help in this topic would be appreciated. If you have a better way of storing and accessing data inside the grasshopper I would like to know about that also.
With best regards