Read Excel File Write into Revit ERROR

1

image.png1219×735 98 KB

I am working on customizing the Write to Excel from Revit and then Read from Excel to Write into Revit. I want to be able to edit the Room Catergory Numbers is Excel and have them update the Revit model, but I keep getting the same error
Warning: Element.SetParameterByName operation failed.
The parameter’s storage type is not a number.
What am I doing wrong, thanks in advance!

2

@LeslieLinsmier Introduce a String from Object node between List.GetItemAtIndex and Element.SetParameterByName

3

Vikram thanks that worked but I now have a decimal point with five trailing zeros…

Capture.PNG951×623 67.9 KB

Thanks for the quick reply and how do I remove the decimal point and extra zeros??

4

create empty python node and paste:
OUT = [str(i) for i in IN[0]]

5

@LeslieLinsmier As the numbers are all integers you could try introducing Math.Floor or Math.Ceiling
Hope this conveys the idea…

20170406-4.png640×506 21.4 KB

6

Tomasz thanks your method and Vikram’s both worked…new to this but I find what you can create and manipulate is A M A Z I N G!!!
T H A N K Y O U B O T H

Leslie

1 Like
7

Vikram,

Thanks worked like a champ, I appreciate your assistance!

Capture.PNG1333×759 93.8 KB

Will post final Script here for others, sharing is caring!

1 Like