Excel Copy and Paste Truncates Data in AutoCAD

[kmacsys]

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.

 

[cadkid]

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."

 

[kmacsys]

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"...!!!

 

[tigrek]

Cute that... $49.-

 

[D55]

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.