Importing Excel into Revit Schedules

[jjohnson]

So I know there are apps and add-ins for Revit to allow you to Import from Excel into Revit. What I'm trying to figure out is which is the best and most user friendly and how exactly do they work. My main objective is to use this for creating sheet list schedules in Revit. I know you can create schedules from linked files, and that works great when you have all your sheets in Revit, but when there is a combination of sheets from multiple platforms (like ACAD) the only workaround I've found is just creating dummy sheets in a model file for the ACAD versions. So my thought is that we have an overall sheet list anyways in excel, so how can I just link that into Revit, create a schedule, and have that update as changes are made to the excel file.

I'm looking at Excel2R, so any thoughts on that add-in would be helpful. Also when importing the info from excel to a sheet list schedule, does it just automatically create dummy sheets?

Thanks in advance for any help/thoughts.

[jeremytammik]

First of all, I would forget the proprietary Excel word and use something generic like CSV or JSON instead.

It is much easier to handle, avoids messing around with Microsoft proprietary stuff, and you can easily hook up with Excel anyway.

Here is a sample that shows how to parse CSV and JSON data and read it into a Revit add-in:

https://github.com/jeremytammik/rvtmetaprop

Once you have the data read in, you can use the schedule API to create and populate a schedule:

https://knowledge.autodesk.com/search-result/caas/CloudHelp/cloudhelp/2016/ENU/Revit-API/files/GUID-...

Oh, I found a discussion of this on the Building Coder as well:

http://thebuildingcoder.typepad.com/blog/2014/07/teaching-a-man-how-to-fish-and-schedule-creation.ht...

It mentions a couple of SDK samples to take a look at.

Sorry, it is not as polite as I would prefer...

I hope it helps anyway  🙂

Cheers,

Jeremy

[aignatovich]

Hi, I have the solution for you, it almost works as Exel2R, it creates draft views with selected excel sheet content and it has ability to refresh data from excel file. It can draw really big sheets (excel2R does not). You can contact me via private messages on this forum.