What is the Best and most effective way to Import an Excel file into AutoCAD 2012?
|
What is the Best and most effective way to Import an Excel file into AutoCAD 2012?
there is no 'best'. there are multiple ways to accomplish that, and there's going to be a specific situation where any one of them is the 'best' choice.
CADTAG is correct.
My usual method is to copy from excel and pastespec as autocad entities, so that it comes in as an autocad table.
Melanie Stone
@MistresDorkness
Archibus, FMS/FMInteract and AutoCAD Expert (I use BricsCAD, Revit, Tandem, and Planon, too)
Technical Editornot all those who wander are lost
R.K. McSwain | CAD Panacea |
We do it a few ways.
1. Melanie pointed out one.
2. We also highlight the table in excel and simply paste it in AutoCAD.
3. Insert an AutoCAD table and link it to your excel table as a data link. This works really well, but there are exceptions as to items that will be shown correctly (i.e. superscript and subscript text)
I typically like to use a data link into a table if I know that there is a chance that the excel file will need to be updated.
I have had issues in the past, pasting in a work or excel file (which makes it an OLE) with either the CAD file not updating or the source file (word, excel, etc) not updating.