I am trying to get the index of a string from excel to dynamo. For example, I want to get the index of the column and row from the string “banana” . I want to be able to get the index (column B and row 3 in this case). Then from this index, I will add from Dynamo the data from the Quantity row to excel.
My idea is something similar to the following script:indexexcel.dyn (21.2 KB) INDEX.xlsx (8.1 KB)
Thanks for yout help