AutoCAD 20007 - Override Excel font when importing into an AutoCAD Table

[mikesal]

Is there a way to override the font extracted from an excel file to a acad table without having to go into every cell in a table to do it? I have tried the filter and qselect options however the font is embedded in the mtext inside the table. We are using acad r2007.

Thx,
Mike

[ccowgill]

I dont know of an easy way to do so, unless someone has figured out a way to do it using lisp or vba.

[CADDmanVA]

Not in 2007. The new data linking feature in 08 fixed that problem. The best suggestion I have is use your CADD Standard font in Excel before you import. Like Chris said, you may have luck with LISP routine if you can find one. Try begging the LISP gurus in the forums...it's worked for me before :lol:.

[Mike.Perry]

Hi

See if the following will work for you...

ID: TS1064307 - Formatting of inserted Excel table is not as expected (http://usa.autodesk.com/getdoc/id=TS1064307)

Have a good one, Mike

[mikesal]

Thank you very much TS1064307 fixed the problem.....

Mike

[ccowgill]

I finally got around to creating a lisp routine for this problem, it only takes care of text style at this point, I suppose the next part to look at is text height, but I dont know if that is really an issue.

This (http://forums.augi.com/showthread.php?p=706512#post706512)is where you can get the lisp routine

[Capt. Computer Crasher]

Is there a way to override the font extracted from an excel file to a acad table without having to go into every cell in a table to do it? I have tried the filter and qselect options however the font is embedded in the mtext inside the table. We are using acad r2007.

Thx,
Mike


You can change the table style or you can edit more than one cell at a time by using the control and shift keys

[Capt. Computer Crasher]

Is there a way to override the font extracted from an excel file to a acad table without having to go into every cell in a table to do it? I have tried the filter and qselect options however the font is embedded in the mtext inside the table. We are using acad r2007.

Thx,
Mike

Something else if you right-click your table after paste special hit remove all overrides then adjust the table style. if the table style you want is already assigned switch to another then switch back to your chosen style.

[djfreaq]

Thank ccowgill so much for writing that lisp. I wish I knew more about it.

I used it for stripping my tables for my datalinks and it worked great. Now I have to figure out how to modify the code so it changes the text height based on dimscale.

Thanks!

---Adam

[seanbaski]

ccowgill your table stripping lisp works great except it doesn't revert the color overrides back to the table entity default color.

Thanks,
Sean
ACAD C3D 2010/Windows XP/Windows 7

[AdamKS]

Boy, if ever there was a time I could use this Lisp, it's right now. Looks like the link has fallen prey to the ravages of time, as 15 years after posting it has unfortunately vanished!

[Ed Jobe]

Are you talking about the link in post #6? It works for me.