See the top rated post in this thread. Click here

Results 1 to 10 of 10

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

  1. #1
    Member
    Join Date
    2002-12
    Posts
    30
    0 Did you find this post helpful? Yes

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

    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

  2. #2
    Certifiable AUGI Addict ccowgill's Avatar
    Join Date
    2004-08
    Location
    Hartford, Michigan
    Posts
    3,095
    0 Did you find this post helpful? Yes

    Default Re: AutoCAD 20007 - Override Excel font when importing into an AutoCAD Table

    I dont know of an easy way to do so, unless someone has figured out a way to do it using lisp or vba.
    Christopher T. Cowgill, P.E.
    WIGHTMAN & ASSOCIATES, INC.
    ENGINEERING <> SURVEYING <> ARCHITECTURE
    AutoDesk Infrastructure Design Suite Premium 2014 x64
    Windows 7 Pro x64

  3. #3
    All AUGI, all the time CADDmanVA's Avatar
    Join Date
    2006-12
    Location
    New Orleans, LA
    Posts
    881
    0 Did you find this post helpful? Yes

    Default Re: AutoCAD 20007 - Override Excel font when importing into an AutoCAD Table

    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 .
    I loved the NCS so much, I joined the committee!

    "Truth suffers from too much analysis"
    I remember AutoCAD R10

    When will Autodesk port AutoCAD to Linux?

  4. #4
    Administrator Mike.Perry's Avatar
    Join Date
    2001-03
    Posts
    13,523
    0 Did you find this post helpful? Yes

    Default Re: AutoCAD 20007 - Override Excel font when importing into an AutoCAD Table

    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

  5. #5
    Member
    Join Date
    2002-12
    Posts
    30
    1 Did you find this post helpful? Yes

    Default Re: AutoCAD 20007 - Override Excel font when importing into an AutoCAD Table

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

    Mike

  6. #6
    Certifiable AUGI Addict ccowgill's Avatar
    Join Date
    2004-08
    Location
    Hartford, Michigan
    Posts
    3,095
    0 Did you find this post helpful? Yes

    Default Re: AutoCAD 20007 - Override Excel font when importing into an AutoCAD Table

    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
    Christopher T. Cowgill, P.E.
    WIGHTMAN & ASSOCIATES, INC.
    ENGINEERING <> SURVEYING <> ARCHITECTURE
    AutoDesk Infrastructure Design Suite Premium 2014 x64
    Windows 7 Pro x64

  7. #7
    All AUGI, all the time Capt. Computer Crasher's Avatar
    Join Date
    2006-12
    Location
    South of North & East of West
    Posts
    786
    0 Did you find this post helpful? Yes

    Default Re: AutoCAD 20007 - Override Excel font when importing into an AutoCAD Table

    Quote Originally Posted by 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

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

  8. #8
    All AUGI, all the time Capt. Computer Crasher's Avatar
    Join Date
    2006-12
    Location
    South of North & East of West
    Posts
    786
    0 Did you find this post helpful? Yes

    Default Re: AutoCAD 20007 - Override Excel font when importing into an AutoCAD Table

    Quote Originally Posted by mikesal View Post
    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.

  9. #9
    Member djfreaq's Avatar
    Join Date
    2008-02
    Location
    Gig Harbor, WA
    Posts
    19
    0 Did you find this post helpful? Yes

    Smile Re: AutoCAD 20007 - Override Excel font when importing into an AutoCAD Table

    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

  10. #10
    Member
    Join Date
    2010-05
    Posts
    3
    0 Did you find this post helpful? Yes

    Default Re: AutoCAD 20007 - Override Excel font when importing into an AutoCAD Table

    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

Similar Threads

  1. Clear Font Override Inside Cells of Table Entity
    By harilalmn in forum VBA/COM Interop
    Replies: 0
    Last Post: 2011-03-10, 12:08 PM
  2. Importing Autocad SHX Font
    By kshawks in forum Revit Architecture - General
    Replies: 5
    Last Post: 2006-12-14, 08:19 PM
  3. Importing Excel 97 to Autocad 2005
    By eddieb99 in forum AutoCAD General
    Replies: 3
    Last Post: 2005-11-01, 11:35 PM
  4. Importing Excel Spreedsheets to AutoCAD 2005?
    By stephen.coff in forum AutoCAD General
    Replies: 2
    Last Post: 2005-08-29, 12:23 PM
  5. Importing excel into AutoCAD 2006 & 2005
    By MikeM4OSU in forum AutoCAD Tables
    Replies: 5
    Last Post: 2005-06-14, 02:50 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •