I created a string to import parameters from multiple families into Excel. The issue I am having is getting the information from Excel back into Revit. I can get it to write back to Revit. But, I need to sort the cells in Excel, lowest to highest. Make changes and then load those changes back into Revit. When I do that, changes are not made to the families I was intending the changes to be made to.
Example:
-Export a # parameter from 6 different families into Excel.
-Cell A6 has a number I need to change.
-I need to sort the #'s by lowest to highest, because they are out of order numerically
-So I sort them lowest to highest
-The number that I need to change was in A6 and went to A23.
-I change the number
-I then import it back into Revit.
-The # did not change on the correct family
-Another families # changed. Problem. Big problem
It seems as if when I sort the numbers lowest to highest. The numbers go in order but change to whichever families parameter was in that row in Excel. The family that the parameter is attached to does not move with the sort.
Is there anyway to get this to work correctly. I’ve been working on this for almost 2 days. Can’t figure it out. Any help would be great. Thanks!