Author Topic: Excel and Autocad Cell Dimensions  (Read 2250 times)

0 Members and 1 Guest are viewing this topic.

blahdc

  • Guest
Excel and Autocad Cell Dimensions
« on: October 13, 2011, 02:02:10 PM »
Hi,

I have been copying and pasting my excel tables into an AutoCAD drawing. I use the following method:

Command:pastespec
Paste as Link
AutoCAD Entities


This method works well as I can update the fields in my excel table and they will update in the drawing. AutoCAD must autofit the row and column height when you import. Is there a workaround so that AutoCAD will use the dimensions from your Excel table?

Thanks!!

Matt__W

  • Seagull
  • Posts: 12955
  • I like my water diluted.
Re: Excel and Autocad Cell Dimensions
« Reply #1 on: October 13, 2011, 02:13:23 PM »
There's a feature in AutoCAD to link Excel files so you won't have to keep copying/pasting each time you make an update.  I can't remember the name of the command at the moment and since I primarily use Revit, I'm getting further and further out of touch with AutoCAD (which isn't necessarily a BAD thing  :wink:)
Autodesk Expert Elite
Revit Subject Matter Expert (SME)
Owner/FAA sUAS Pilot @ http://skyviz.io

DogBone

  • Guest
Re: Excel and Autocad Cell Dimensions
« Reply #2 on: October 17, 2011, 07:23:53 PM »
DataLink   :kewl:

Drafter X

  • Swamp Rat
  • Posts: 578
Re: Excel and Autocad Cell Dimensions
« Reply #3 on: October 17, 2011, 07:34:25 PM »
Yup, create a tablestyle that meets your needs, then data link tables using that style and they will always look correct. I use the hell out of data links, love them.
CadJockey Militia Commander