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 .

[Mike.Perry]

Hi

See if the following will work for you...

ID: TS1064307 - Formatting of inserted Excel table is not as expected

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 is where you can get the lisp routine

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

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