Element63 Posted August 22, 2007 Share Posted August 22, 2007 I'm trying to import an excel sheet into autocad and i'm having some trouble with extra lines showing up. i'm selecting all the lines on the sheet and copying them, then pasting them into autocad using paste special. The problem is that all the "invisible lines" in the excel file are showing up as solid lines in Autocad (2008). example: so if i have only 1 line typed in a row that is three lines high i get 2 extra lines under the typing that i do not want. Does anyone know how to copy an excel file to Autocad and not have the "invisible lines" in excel show up in the autocad file? Thanks. Quote Link to comment Share on other sites More sharing options...
SLW210 Posted August 22, 2007 Share Posted August 22, 2007 In Excel, you can turn of the grid. Under Tools>Options uncheck the gridlines box. Quote Link to comment Share on other sites More sharing options...
Element63 Posted August 22, 2007 Author Share Posted August 22, 2007 In Excel, you can turn of the grid. Under Tools>Options uncheck the gridlines box. The lines still show up in autocad when i uncheck the gridlines box. They arent showing up in the excel file but still are in autocad when i paste entities... thanks though. Anything else you recommend? Quote Link to comment Share on other sites More sharing options...
SLW210 Posted August 22, 2007 Share Posted August 22, 2007 Did you _Purge your drawing before reinserting your file? Quote Link to comment Share on other sites More sharing options...
rustysilo Posted August 22, 2007 Share Posted August 22, 2007 Could you perhaps paste as an AutoCAD table and then toggle your border display in the properties box? Quote Link to comment Share on other sites More sharing options...
Element63 Posted August 22, 2007 Author Share Posted August 22, 2007 Did you _Purge your drawing before reinserting your file? Tried purging the autocad drawing before and after pasting the excel document in....still cant get rid of the lines Quote Link to comment Share on other sites More sharing options...
Element63 Posted August 22, 2007 Author Share Posted August 22, 2007 Could you perhaps paste as an AutoCAD table and then toggle your border display in the properties box? That gives all the same options as copy pasting entities. Quote Link to comment Share on other sites More sharing options...
SLW210 Posted August 22, 2007 Share Posted August 22, 2007 I will check into it for you...Give me a few minutes. Quote Link to comment Share on other sites More sharing options...
SLW210 Posted August 22, 2007 Share Posted August 22, 2007 Turning gridlines on and off is working for me. Let me see if there is a system variable somewhere. Quote Link to comment Share on other sites More sharing options...
Element63 Posted August 22, 2007 Author Share Posted August 22, 2007 Turning gridlines on and off is working for me. Let me see if there is a system variable somewhere. are you doing >paste special >AutoCad Entities ? Quote Link to comment Share on other sites More sharing options...
SLW210 Posted August 22, 2007 Share Posted August 22, 2007 No I just drag and drop or insert OLE. I just did paste special and still no gridlines. Quote Link to comment Share on other sites More sharing options...
Element63 Posted August 22, 2007 Author Share Posted August 22, 2007 No I just drag and drop or insert OLE. I just did paste special and still no gridlines. when you do the paste special does it show up with no backgound on it? or does it show up with a backgound? Quote Link to comment Share on other sites More sharing options...
SLW210 Posted August 22, 2007 Share Posted August 22, 2007 No background shows up like text. Quote Link to comment Share on other sites More sharing options...
Element63 Posted August 22, 2007 Author Share Posted August 22, 2007 well i figured out a way to make the lines disapear..... all i do is explode the chart once it is in autocad then delete the extra lines. good enough for me. thanks for all the help SLW210 Quote Link to comment Share on other sites More sharing options...
SLW210 Posted August 23, 2007 Share Posted August 23, 2007 Wish I could have been more help, but you are welcome. Quote Link to comment Share on other sites More sharing options...
ironfozzy Posted January 29, 2010 Share Posted January 29, 2010 I'm trying to import an excel sheet into autocad and i'm having some trouble with extra lines showing up. i'm selecting all the lines on the sheet and copying them, then pasting them into autocad using paste special. The problem is that all the "invisible lines" in the excel file are showing up as solid lines in Autocad (2008). example: so if i have only 1 line typed in a row that is three lines high i get 2 extra lines under the typing that i do not want. Does anyone know how to copy an excel file to Autocad and not have the "invisible lines" in excel show up in the autocad file? Thanks. I know this thread is a few years old but after searching for the solution to this issue I've finally figured out the solution. The problem lies not in the data link but in the Table Style that you select when you create the table with the TABLE command. It seems AutoCAD will combine your local table style settings with the spreadsheet's own formatting. The "Standard" table style will draw a border around every cell. To fix this, simply edit the table style and turn off all borders for each section (title, header, data) and save. Now the table style will not interfere with Excel's formatting and all the extraneous borders will go away. Quote Link to comment Share on other sites More sharing options...
T704 Posted January 30, 2010 Share Posted January 30, 2010 Work For Me Too Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.