I have an Excel spreadsheet that I can successfully connect to Dynamo, and I want to select a particular item from that spreadsheet based on a number that changes depending on what object I select in my linked drawing (Civil3D .dwg file). Right now I can successfully select the object in my drawing, but I am unable to work the lists to give me the corresponding data from the chart.
As an example (refer to the attached image), I can successfully pull in the number “200” into the Dynamo canvas, but I am unable to extract out the number “2” for size or “240” for amount. Yes I could put in a number manually that says “200”, but I need it to come from the chart, because I want to select item “201” as well and have it return those numbers. Most importantly, the “size” and “amount” numbers may change over time, as I intend this script to be used multiple times with one ever-changing spreadsheet.
I have tried several things, from transposing the list to shifting the cells, but I am stuck. Does anyone have any ideas on how I can get over this hurdle?