Grasshopper - Disabling Read Excel Sheet

Hello,

I am using the “Read Excel Sheet” Component from the TT toolbox. The workflow I am trying to achieve goes something like this:

  1. Read excel data and bring it into grasshopper.
  2. Manipulate the data as needed within grasshopper and output it downstream to the remainder of my script.
  3. Disable the “Read Excel Sheet” component while retaining the data from it inside grasshopper.

Here is an image of my script.

I would like to disable the component circled in blue while maintaining the information circled in red. The problem is that when I disable the “Read Excel Component” , all the data circled in red disappears and so does the rest of my geometry. The “Read Excel Component” is causing grasshopper to lag so that is why I would like to disable/enable it automatically based on an event that occurs upstream.

Any suggestions on how to get around this?

Thank you!

you can right click on Data (or even add a Data Parameter in between), and choose “internalise Data”

whenever you want to go back with the Excel file you can just reconnect the wire that in the meanwhile will disappear

Thanks for the response. But I would like to have it such that I do not have to manually reconnect the wire every time. I want it to update automatically whenever the data changes. So it will be almost like the data is internalized temporarily, but when the data changes it updates and then re-internalizes. Is this possible?

you might try a Data Dam component between the Excel and the Explode Tree
but consider that data inside the Data Dam will not survive a file open/close

Used the data dam and it does help to get the workflow to behave the way I want it to. However, the Data Dam component itself is causing the lag now. I suppose there is no other work around for this?

I could of course delete it and then add it back, but that makes my script a bit user-unfriendly.