Excel to Revit via Dynamo Converts Numbers to Text
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?
Re: Excel to Revit via Dynamo Converts Numbers to Text
Are you able to share your Dynamo script with a sample Excel spreadsheet and Revit model?
3 Attachment(s)
Re: Excel to Revit via Dynamo Converts Numbers to Text
Attachment 109065Attachment 109066Attachment 109067
Hopefully this all attached properly. I'm sure it's not self explanatory so hit me with your questions.