Writing data to Excel and back into Grasshopper

Grasshopper
, ,
1

I am trying to export data from grasshopper to an excel sheet, which then calculates a value which I want to give back to grasshopper. I am using the Excel Write LEGACY and Excel Reader LEGACY components. The problem is that the Reader component only reads the data once, even if the toggle is continuously on ‘True’. This means the data in the excel sheet can get updated, but it won’t be read by the component. Is there a way to fix this?

2

Hi @T.W.L.vanderLinden ,

Not the best or most elegant solution but you can attach a trigger component to the excel reader with a time of say 5 seconds or something and this will ensure it’s updating the content every 5 seconds

3

Use File Path parameter for file input and enable sync.

4

This works for now, thanks!

1 Like
5

The excel write and read components I am using do not have an input to determine which file to use, they just use an opened excel file. Are you talking about the components from LunchBox?

6

You’re welcome!