• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Discussion Groups

    AutoCAD 2010/2011/2012 DWG Format

    Reply
    New Member
    Posts: 1
    Registered: ‎04-03-2012

    imported excel table - table lines keep showing up

    443 Views, 5 Replies
    04-03-2012 10:15 AM

    Hi all,

     

    I have been struggling with this for a while, and I can't seem to find a solution.

     

    I have a table imported into autocad from excel, however despite the table (excel) being formatted, border lines appropriately placed and hidden througout the sheet, all off the border lines of the cells appear when imported into autocad.

     

    is there anything i can do to hide back some border lines for selected cells?

    Please use plain text.
    Active Contributor
    Fantoon
    Posts: 44
    Registered: ‎05-10-2011

    Re: imported excel table - table lines keep showing up

    04-12-2012 11:57 PM in reply to: ian.iankim

    I would be interested in this as well. My cad model isn't updated properly with my excel sheet.

    AutoCad 2011 & Civil3D 2011. Product Version 3.
    EliteBook 8560w
    Intel i7 CPU 2820QM @ 2.3GHz
    8 GB RAM
    NVIDIA Quadro 1000M
    Windows 7 Enterprise 32 Bit :smileysad:
    Please use plain text.
    Contributor
    Posts: 24
    Registered: ‎06-20-2008

    Re: imported excel table - table lines keep showing up

    12-12-2012 08:43 AM in reply to: ian.iankim

    I have been having a similar issue when printing to PDF from AutoCAD my Excel spreadsheets show up with gridlines that are not there in there Excel or CAD. I have tried a number of things to eliminate that lines (see list below) but nothing has worked so far. I am running AutoCAD 2012 and Excel 2003. I have inserted the spreadsheet using "Paste Special" so that I can continue to work on the spreadsheet in excel and it will update in CAD.

     

    -  I have changes the Plot Quality. In Monochrome the lines print. Low quality the spreadsheet does not show up. High quality again nothing shows up

     

    - In Excel I have turned off the "Gridlines" and re-copied into AutoCAD. The lines still show up when printing to PDF

     

    - If I paste as an AutoCAD Entity I can not update in Excel

     

    Please let me know if you have any other ideas. I would really like to get this to work.

    Please use plain text.
    *Expert Elite*
    pendean
    Posts: 14,896
    Registered: ‎11-06-2003

    Re: imported excel table - table lines keep showing up

    12-12-2012 12:53 PM in reply to: beh160

    AFAIK there is not much to fix :smileysad:


    Dean Saadallah LT BLOG | RSS Feed | LT Tips | PINS
    Please use plain text.
    *Expert Elite*
    Posts: 1,525
    Registered: ‎05-21-2008

    Re: imported excel table - table lines keep showing up

    12-17-2012 10:31 AM in reply to: pendean

    Works for me.  Gridlines turned off in Excel, don't show up in CAD or on plots.  Working in 2011.

    I am using plane old paste, not paste special.

    I am plotting to a .plt file, and send to KIP plotter.

    __________________________________________________________
    Win 7 Pro, 32 bit; Intel Core i5 @ 2.80GHz; 4GB RAM—Civil 3D 2008 & 2011
    __________________________________________________________
    Credit where credit is due! Give kudos or accept as solution whenever you can.
    Please use plain text.
    Contributor
    Posts: 24
    Registered: ‎06-20-2008

    Re: imported excel table - table lines keep showing up

    12-18-2012 08:39 AM in reply to: ian.iankim

    I was able to get this to work but only if I print using DWG to PDF.pc3. This is not how we normally print and causes some headache with settings but at least I have gotten it to work. I still do not understand why this would not work using Adobe PDF, which we have installed as one of our printers.

    Please use plain text.