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?
I would be interested in this as well. My cad model isn't updated properly with my excel sheet.
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.
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.
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.