Tuesday, February 22, 2011

Copy Cells from Excel to Revit Schedule

***********
This utility has been updated for Revit 2012 and for 64bit version for 2011 Revit.
***********
I had created a script to Copy Cell values from Excel to Revit Schedule view. I updated the script for 2011. The evaluation copy of the updated script for Revit 2011 and 2012 is available at:
http://bim.nichitecture.com/copyexcel.html
I hope this is helpful.
The script works with both Microsoft Excel and Open Office.org Calc.
The script copies a bunch of cells (rows x columns) and pastes them into a revit schedule (contiguous rows x columns).

  1. The script works well if all the fields in Revit schedule are EDITABLE. (A normal schedule has lots of ‘read-only’ fields like Family name, Area, etc where this script will fail.) The cells also need to be 'instance' driven cells (as compared to 'type' driven cells)
  2. The script does not create blank rows for data in Revit (yet). You need to create as many rows as you might need using this button in the Revit option bar before running the script.

No comments: