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?
Re_TableLookup.gh (12.8 KB)
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:
- Solution exception:Could not load file or assembly ‘CORE.Library.Office, Version=220.127.116.11, 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!