PDA

View Full Version : 2021 Excel to Revit via Dynamo Converts Numbers to Text



gregb
2022-03-09, 10:58 PM
I am trying to write a Dynamo script that will give me the total square footage of Areas grouped by certain parameters which I can then bring back into Revit to use in plumbing fixture calculations. I've managed to get the information written to an Excel file but when I try to import the values from Excel into Revit the square footage gets converted from a number to text. I keep seeing people commenting on how values imported from Excel can be set as numbers but nobody is providing instructions. Could someone please tell me how I can get numbers from my Excel spreadsheet to come into Revit as numbers?

Opie
2022-03-10, 02:09 PM
Are you able to share your Dynamo script with a sample Excel spreadsheet and Revit model?

gregb
2022-03-29, 04:58 PM
109065109066109067

Hopefully this all attached properly. I'm sure it's not self explanatory so hit me with your questions.