CAD PANACEA HAS MOVED TO http://cadpanacea.com
01 July 2005
Excel -> TABLE entity          
Here is something I ran across today, using 2006.

Copy two columns of text from Excel spreadsheet to clipboard.
In Excel, the first column is formatted as 'General' and the second column is formatted as 'Number', set to 2 decimal places.
Edit | Paste Special into AutoCAD - as AutoCAD Entities
Resulting object is a TABLE.

First column in AutoCAD table is fine.
Second column of text is formatted like this:

{\fArial|b0|i0|c0;\H0.463x;5,303.21}

We don't want this text 0.463 times it's HEIGHT value (defined in the TABLE style). The font wasn't a big issue, but why not just let all of the imported text assume the properties of the current TABLE STYLE?

"Remove all property overrides" does not help (and it shouldn't)
"Remove Formatting" is grayed out in the context menu.

The only way to remove the formatting is through PROPERTIES, one at a time.

Wait, there is another way. Export the table from AutoCAD to CSV. Then open that file and repeat the copy/pastespec sequence. Better yet, export the original Excel file to CSV, then import it ONCE.

Based on that, it appears that if you remove the Excel formatting, you get nice clean TABLE objects in AutoCAD with no formatting applied to the text itself.

PermaLink       Posted 7/01/2005 06:58:00 PM     
3 COMMENTS!


Comment from: Anonymous Terry W. Dotson
Date: July 20, 2005 at 8:09:00 PM CDT  

In Excel, before copying the range choose Format > Cells. On the Font tab click the 'Normal Font' making sure its a solid check. Then do the copy and paste to table. The resulting table will not contain the formatting codes and you can simply undo in Excel, or don't save.


Comment from: Blogger R.K. McSwain
Date: July 21, 2005 at 8:10:00 PM CDT  

Leave it to Terry to come up with a better option...

Thanks!


Comment from: Anonymous Anonymous
Date: June 30, 2006 at 4:58:00 PM CDT  

In Excel 2003 I have to change the 'style' to normal to achieve this result. Thanks to Terry for the posting, we've been working in misery since our I.T. department 'upgraded' our workstations to Windows XP.

Yours is the only solution that works every time, all the time!

David

Post a comment