How to export in imperial units using XLS Export?

Tools
1

Hey, I’ve run into a small question and wanted to ask for some advice: I used the XLS Export function, but all the data in the exported Excel file comes out in metric units (e.g., millimeters, square meters). However, my Revit model is clearly set up in imperial units (feet, square feet).

Is there a default setting for this function, or did I miss a step somewhere? Is there an option to switch the units during export?

I’d really appreciate any pointers when you have a moment. Thanks!

2

That’s wierd. Did you only set up these units in the schedule you’re trying to export? There it currently isn’t respected, but a PR is in the works.

The 5.3.1 version should export all measurables in project units defined here:

image
image381×160 6.84 KB

if param_val.StorageType == DB.StorageType.Double:
    forge_type_id = get_parameter_data_type(param.definition)
    val = param_val.AsDouble()
    if forge_type_id and DB.UnitUtils.IsMeasurableSpec(forge_type_id):
        unit_type_id = param_val.GetUnitTypeId()
        val = DB.UnitUtils.ConvertFromInternalUnits(
            param_val.AsDouble(), unit_type_id
        )