sisea.search

Edit Revit Property and Cell Units via Excel with Ideate BIMLink

Default Units

Ideate BIMLink exports numeric Revit property values to Excel using the default units defined within Revit. If the default unit in Revit is set to feet and fractional inches, Ideate BIMLink will export the value as a decimal value with three places. Numerical values imported from Excel are also interpreted as having the default units defined in Revit.

See Revit menu: Manage tab ►Settings panel ► (Project Units)

NOTE: Revit's Properties palette does NOT use the unit format specified within Project Units. It has its own, hard-wired format.

Imperial Units - Fractional Inches

Excel does not support imperial format for length values in the same way that Revit does, with both the feet and inches syntax. Therefore, when dealing with Imperial length units, feet and fractional inches are displayed as decimal feet, and fraction inches are displayed as decimal inches. Even though the values are exported using numerical values, for importing purposes, these number formats are acceptable: 6'1 or 73" or 6'-1".

Formatting Dates

Excel will try to automatically convert certain types of text string data into the Date format if an edit is made. For example if you type in 3-03-12 it will change the Cell format from "General" to "Date" and will also change the underlying cell value. Unfortunately this also alters how the information is imported back into Revit via Ideate BIMLink. In these situations there are two recommended workarounds.

Type the ' character in front of the date. This will force the cell to retain its "General" text string format and read exactly as it is written. For example you can type into the cell: '31-05-13 to signify May 31st, 2013 and the value will read into Revit as expected.
Use the dd/mm/yy, mm/dd/yy syntax and Excel will also not try to convert it to a text string.

Submit feature or issue request for Ideate Software

Thank you for taking time to inform us about a bug or feature request.

Your Email Address * Software: Version: Bug or Feature Description: GDPR Opt-In:*

By entering your data above and clicking ‘SUBMIT’ you are consenting to the collection and use of that data to respond to your comments and inquires, as described in our Privacy Policy. We may also transfer the data you submit in the ‘Email Us’ form to our VAR partners for the limited purpose of a sales follow-up. Please review our Privacy Policy for more details on how and when we collect data and what we use it for.