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
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
RE: Excel Copy and Paste Truncates Data in AutoCAD
RE: Excel Copy and Paste Truncates Data in AutoCAD
Only problem is it won't carry over any word wrapping you may have in a cell.