Please help, I am trying to create a script to read and filter data in an excel file. I want it to look for data in the excel file based on the CES Previous Number then fill out other parameters based on that row in excel. For example I have loaded into the project AB-01 I want it to search for AB-01 in Column I then take the data from the same row but in column K and add it to the CES Description Parameter of that family.
Test Excel.xlsx (22.0 KB)
Test with Component.rvt (7.2 MB)
Parameter write from excel test.dyn (34.5 KB)
BWWSharedParam.txt (16.1 KB)