AutoCAD 2010/2011/2012

AutoCAD 2010/2011/2012

Reply
New Member
ian.iankim
Posts: 1
Registered: ‎04-03-2012
Message 1 of 6 (857 Views)

imported excel table - table lines keep showing up

857 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?

Active Contributor
Fantoon
Posts: 46
Registered: ‎05-10-2011
Message 2 of 6 (802 Views)

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:
Active Contributor
beh160
Posts: 29
Registered: ‎06-20-2008
Message 3 of 6 (679 Views)

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.

*Expert Elite*
pendean
Posts: 22,386
Registered: ‎11-06-2003
Message 4 of 6 (671 Views)

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 Blog | Facebook | Google+ | Twitter | PINS
*Expert Elite*
troma
Posts: 2,520
Registered: ‎05-21-2008
Message 5 of 6 (642 Views)

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.


Credit where credit is due! Give kudos or accept as solution whenever you can.

Active Contributor
beh160
Posts: 29
Registered: ‎06-20-2008
Message 6 of 6 (622 Views)

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.

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.