Showing posts with label bim utility. Show all posts
Showing posts with label bim utility. Show all posts

Wednesday, May 1, 2013

Copy Spreadsheet for Revit 2014 - released!

Revit Schedule is quirky. It is fantastic in many aspects, but lacks in one specific simple manipulation.
For eg., if you maintain a set of data in Microsoft Excel (or Open Office or Libre Office spreadsheet) and want to copy and paste it into a Revit schedule, it is not possible.
Since, the Revit schedule is made of elements within Revit, copying and pasting data from any other spreadsheet is not allowed. In order to alleviate this issue, we have coded the Copy Spreadsheet for Revit utility. This just does that!
We have updated the popular copy spreadsheet for Revit utility for the 2014 version. The trial version is available here. The trial version is limited to copying only 3x3=9 cells at a time.
You can buy the fully functioning utility from here.
The full version allows copying of unlimited number of cells.

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.