My task is to take an excel spreadsheet that has a list of unit selections from a vendor, extract and organize the data I need, and push that information into a set of parameters. After a lot of searching and reading previous posts, I’ve hit a wall.
To this point, I’ve essentially:
- created a filter to list only the elements I need to push information into
- formatted the information in the excel into a series of sublists
- used a dictionary to put the information in the same sequence
The problem is when I finally try to write the information to the parameters. Some of the parameters write, and some don’t. From what I can tell, the parameters that don’t write get removed from the list, and the subsequent value that can write moves up to the next available parameter on the list. The latest error I received states, “The parameter’s storage type is not a number.” I’ve gone through the excel spreadsheet to ensure that the cell format matches the parameter’s; I assume that any parameter formatted for engineering info (non-text) will accept numbers, so I tried to match up text with text and numbers with numbers/engineering values. I’m at a loss and I have a lot of data to compile in Revit.
The snip below shows the end of the script where I’m running into issues. The circled part shows where I checked the pairing between the indices in the excel file and the parameters I want to write to.
Any help you can provide would be great. I’ve attached sandbox files for testing.