Anyone have a good work-around for bringing in Excl spreadsheets? Autodesk really needs to add that support. The new table features are an improvement, but Excel is still easier and more efficient for staff in my office.
|
Anyone have a good work-around for bringing in Excl spreadsheets? Autodesk really needs to add that support. The new table features are an improvement, but Excel is still easier and more efficient for staff in my office.
Import excel to autocad using paste-special as autocad entities.
For a better import see Toolpac at dotsoft.com
Then link autocad into REvit.
Out of curiousity, can you give an example of what sort of Excel data you're trying to import?
Guy
I think Leonid sums it up here:BUT...here's a fairly exhaustive thread on importing schedules
And FWIW, the current API allows you import and export spreadsheet data. Just not dynamically. So like I said, what do you want to do?For example in case of Excel it may be better to dynamically read the data from Excel but use Revit own mechanisms to format and display it.
HTH,
Guy
Some of the architects want to import spreadsheets to use a tables. Because those tables are continuously being updated and they are comfortable with Excel, that is what they want to use.
Well, keep in mind a couple of things:Originally Posted by pdavis
1) Every time a table is updated, it will have to be re-imported through the whole Excel to PDF to JPG thing (as mentioned in the thread I made mention to)
2) The quality of the JPG table is not great at full size. Usually, no matter how high the resolution, the tables still look a little grainy and gray.
A slightly different perspective - We are no longer using Excel "in front", but are using Revit to contain virtually all data from pre-design forward. We then portray that data in schedules and/or tags, from very complex space programming, to department summaries, etc. After looking deep, we discovered that if we thought about it, we could begin the project in Revit, before any spaces were defined - then if need be, export to Excel from schedules. It does require a re-think of what "efficiency" means, similar to transitioning from Autocad. It sure looks faster the old way at first glance, but consider what the data represents, and how it will behave in the long run. Note: all of our principals and PA's used to use Excel as a matter of course, but it's swinging around rapidly.