Linking values from grasshopper into excel and back into grasshopper

I am trying to obtain a value from an excel table using two values generated in grasshopper and then putting that found value back into grasshopper. I will probably have to use python to make it happen. Any help would be appreciated!

For Example these two values:

Say that instead of 49 and 33, the value were 22 and 34 I then want to find a value from this excel table according to those two values:

From that, i want the given value (in this case 0.67) to be put back into grasshopper in a pannel.

Hopefully that makes sense

You’ll need a plugin; ttoolbox or NPOI_excel, then find/replace member in set.

I have TToolbox. So i input the two values into the linked excel and it finds the point automatically?

pretty much (12.8 KB)

1 Like

thank you, ill give it a go now with my file and let you know if it works!

I dont seem to be able to link my excel sheet to the readxml.

I have changed the XLSX to and XLS as yours was, but am still not able to read it…

I have also unblocked the dll.s but it still isnt working. I have ran out of ideas and hope you could help me

This is what the error says:

  1. Solution exception:Could not load file or assembly ‘CORE.Library.Office, Version=, Culture=neutral, PublicKeyToken=null’ or one of its dependencies. The system cannot find the file specified.

did you unblock, close rhino and then reopen?

the .xls is due to a save to the 97 format, not a just renaming.

I figured it out. The TToolbox files were in the wrong location. It works perfectly now, thank you!