Results 1 to 4 of 4

Thread: imported excel table goes wonky

  1. #1
    Certifiable AUGI Addict cadtag's Avatar
    Join Date
    2000-12
    Location
    Cairo - no, not Illinois
    Posts
    4,782
    Login to Give a bone
    0

    Default imported excel table goes wonky

    Trying to import a table from Excel, using Paste Special to AutoCAD Entities.uisually this works reasonable well, and gives me something usable I can deliver to clients without worrying.

    this one however, the data is getting scrambled to heck and gone.. usable layout in excel is scattered across mutliple columns and rows. top imae is in excel, lower one is after doing spaste-special as autocad entities. Pasting as Excel does woork, byt doesn't look like the rest of the set and won't make my clients happy.

    Civil3d 2019.
    Attached Images Attached Images
    Real pirates wear silk suits & ties, and write EULAs
    The only thing more dangerous to the liberty of a free people than big government, is big business.

    Toward a Sustainable Water Future: Visions for 2050 http://ascelibrary.org/doi/book/10.1061/9780784412077

  2. #2
    Login to Give a bone
    0

    Default Re: imported excel table goes wonky

    The AutoCAD TABLE Object just isn't capable of recreating the contents of complicated Excel sheets and the stock functionality is less than optimal.

    Here is a graphic example http://www.dotsoft.com/files/xl2cad-vs-tables.gif of what can happen. Anyway given your long history I've got something that WILL make your clients happy http://www.dotsoft.com/xl2cad.htm, check your email.

  3. #3
    Certifiable AUGI Addict cadtag's Avatar
    Join Date
    2000-12
    Location
    Cairo - no, not Illinois
    Posts
    4,782
    Login to Give a bone
    0

    Default Re: imported excel table goes wonky

    Thanks !!
    seems like the biggest issue was with soft returns in the excel cells. Worked fine for the details column, but fubared after that. dumping soft returns helped, but three random double quotes in the beginning and end of some (not all) text strings.

    < Rantmode=on> when tables first came out a decade and a half ago, they were the bee's knees as far as new features. pity that no-one in Adesk seems to understand that drafting annotation is neither word processing, nor spreadsheets, and that their customers _need_ to work with other applications and integrate the output of those applications into contract and construction documents. Neither MText, MLeaders, nor Tables show much improvement (and don't even get me started on linetype handling #%*^^%&#!#!%&!~~!!!! (rantmode=off>
    Real pirates wear silk suits & ties, and write EULAs
    The only thing more dangerous to the liberty of a free people than big government, is big business.

    Toward a Sustainable Water Future: Visions for 2050 http://ascelibrary.org/doi/book/10.1061/9780784412077

  4. #4
    I could stop if I wanted to
    Join Date
    2014-08
    Posts
    378
    Login to Give a bone
    0

    Default Re: imported excel table goes wonky

    [QUOTE=cadtag;1345719]Thanks !!
    seems like the biggest issue was with soft returns in the excel cells. Worked fine for the details column, but fubared after that. dumping soft returns helped, but three random double quotes in the beginning and end of some (not all) text strings.

    < Rantmode=on> when tables first came out a decade and a half ago, they were the bee's knees as far as new features. pity that no-one in Adesk seems to understand that drafting annotation is neither word processing, nor spreadsheets, and that their customers _need_ to work with other applications and integrate the output of those applications into contract and construction documents. Neither MText, MLeaders, nor Tables show much improvement (and don't even get me started on linetype handling #%*^^%&#!#!%&!~~!!!! (rantmode=off>[/QUOTE

    I would have to agree its a pity that Autodesk doesn't understand that not everyone has the same work flow. It's even more of a pity considering the cost of their products that they can't seem to maintain an improving product. It seems that Autodesk has now become the Non responsive Industrial giant that only tells you what to do and do it their way or your wrong. We all have our individual work flows the same as many of us have a differing clientele with different needs. But then that is the way it goes someday some young start up will come along and have a better cheaper product then Autodesk will go the way of Kodak.

Similar Threads

  1. 2017: keynote block in mleaderstyle goes wonky
    By cadtag in forum AutoCAD Annotation
    Replies: 0
    Last Post: 2018-03-30, 01:53 PM
  2. Ordinate dimension is wonky
    By jgratton in forum AutoCAD General
    Replies: 5
    Last Post: 2010-01-20, 12:26 PM
  3. Wonky DB
    By spddesigns in forum Dynamic Blocks - Technical
    Replies: 3
    Last Post: 2007-11-02, 11:54 AM
  4. Wonky duct work
    By david.metcalf in forum Revit MEP - General
    Replies: 0
    Last Post: 2006-09-03, 06:42 PM
  5. Rotation and a wonky stretch?
    By Rico in forum Dynamic Blocks - Technical
    Replies: 14
    Last Post: 2005-11-06, 04:36 AM

Posting Permissions

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