×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Excel Copy and Paste Truncates Data in AutoCAD

Excel Copy and Paste Truncates Data in AutoCAD

Excel Copy and Paste Truncates Data in AutoCAD

(OP)
When I Copy and Paste from Excel into AutoCAD, the data gets "cut off". I find I can only Copy and Paste a small amount of cells. I am using the standard "Copy" command in Excel and using "Paste Special / AutoCAD Entities" in ACAD. ACAD Rel. 14 or 2000 does the same thing.

RE: Excel Copy and Paste Truncates Data in AutoCAD

More information on this subject can be located under
Bert Raccoons post

Here is a recap  

I found this at Autodesk's web site

"When an Excel spreadsheet is pasted, the Picture (metafile) format is used, which can result in the spreadsheet being truncated. This problem can occur when the column width and row height in Excel are set to the default (default width is 8.43, and default height is 12.75), and the pasted object exceeds 18 columns by 70 rows.

Use one or both of these methods to resolve the problem:

Method #1
In Excel, reduce the column width and row height. You can paste more of the spreadsheet if you reduce the column width and row height.

Method #2
Paste the spreadsheet in separate parts. By pasting the spreadsheet in separate parts you can break it down into several smaller OLE objects."

RE: Excel Copy and Paste Truncates Data in AutoCAD

(OP)
Thanks, I have used these methods to "get around the problem" before, especially the idea of using smaller areas. I wonder though, how come one can import a "huge" word doc without this problem! Bill Gates probably knows the answer and has a solution for "only $49"...!!!

RE: Excel Copy and Paste Truncates Data in AutoCAD

Cute that... $49.-

RE: Excel Copy and Paste Truncates Data in AutoCAD

There is also a program out there for a $90 fee called Spanner that will cut and paste your entire spreadsheet.

Only problem is it won't carry over any word wrapping you may have in a cell.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources