I have an excel file. In columns, I have the columns(revit category) location marks. In rows the base level.
I’m trying to get the information from the excel file and set this value into a parameter.
If you see my excel file. A structural column whose location mark is A-1 (grid lines) and whose base level is L000 would get the value “M”.
A structural column in grid B-2 level L011 would get the value “X”.
I’m trying to use a dictionary but honestly I don’t know where to start.
Thank you in advance.
COLUMN_VALUES.xlsx (9.2 KB)