I have searched all of the excel to AutoCAD entities topics and no one has addressed the issue I'm having. When I select my table info in excel, then go into AutoCAD and pastespec to AutoCAD entities, the table comes in, but the text in the table is A., wrong size, B., Wrong font, and C., the wrong color. I've tried setting excel to system font, and I set my desired table style as current, still get text that is the font and size from excel and the color 0,0,0 which is black. see attached screenshots.
Solved! Go to Solution.
Solved by jggerth. Go to Solution.
Yes, that is the second image I attached. by default do you mean set as current style?
Still looking for some assistance on this. If I have to go through and manually change the font size, type and color in each cell, there's no use in using it.
What specific fonts are you using in Excel and are they OpenType, TrueType, or AutoCAD shx fonts? What version of AutoCAD are you using?
The copy/paste special process works fine for me with AutoCAD 2019 using Arial or Times New Roman fonts in Excel/AutoCAD. Both of these fonts are OpenType fonts. Simplex is an old AutoCAD stick font that doesn't work well for me in Excel.
I wondered about the image files pasted into an e-mail reply, here is the file. As for your comments about trying different fonts, our standard is the simplex.shx at the 22 degree slant, our CAD committee is working on making a change, but the way that goes, it'll be another 5 years before we dive into the world of true type fonts.
I can see 365 and autoCAD not playing well together as the reason.
Here is the sample I have been trying to get to work. we use many different schedules most of which are created in excel by engineers. this is just a small footing schedule, most of them are 10 times this size, so a cut and paste, or even a link, would be great, but we need to adhere to our antiquated standards.
Thanks for the files: I get it now I think, you want AutoCAD to fix your Excel formatting. Never going to happen.
Your Excel is not formatted correctly to match your AutoCAD TableStyle; text is too large for the body of the text, cells are not wide enough to accommodate your header text size etc.
Excel also does not understand "header" label you assigned in TABLSTYLE command since you are not using headers in Excel. You will need to assign them after the fact in this case.
There is a lot to fix in the Excel template first before you can start using this ability.
Other factors for simply linking that may be against you all is this https://forums.autodesk.com/t5/autocad-forum/link-excel-to-autocad-dwg-excel-file-format-not-recogni...
ZOMBIEKILLER is a free app from the App store, reveals every AutoCAD variant (and add-ons) that has touched any DWG file.
Nope, thats not what my problem is. The problem is the text coming in from excel is formatted into the mtext entity inside the cell. Therefore, the cell properties are overwritten by the imported text and each cell has to be manually changed by going into the mtext editor. as for the cell size and the "types" of cells, that doesn't matter, that can easily be adjusted in autocad. in the link you sent me, I did notice the 64-bit vs 32-bit issue and checked my 365, it is 32 bit. so maybe that has something to do with it? but unlike the issue in that link, I can connect to the excel files. I think if autocad would just bring the text in as regular "dtext" it would be fine.
Look for a LISP routine called StripMText, and run that against the imported table. That shuld let you eliminate the cell-level Mtext over-rides