rythem_of_the_nig Posted August 29, 2011 Share Posted August 29, 2011 I have an autocad drawing with so many light fixtures with all different names.Now we have to change all those names, i already have an excel sheet containing two columns with first one containing "name in drawing" and second one containing respective "new name". Is there any way to replace the names in cad file using that excel sheet.i just dont want to do all those thousand rename manually ...please some cad-guru help me Quote Link to comment Share on other sites More sharing options...
19cruthik68 Posted September 6, 2011 Share Posted September 6, 2011 Hello! If you already have an excel file for that, just open the excel file highlight it and copy and then paste it in autocad and if there is another changes again, try to double click the one that you paste in autocad and automatically it will bring you to excel Quote Link to comment Share on other sites More sharing options...
Organic Posted September 6, 2011 Share Posted September 6, 2011 Hello! If you already have an excel file for that, just open the excel file highlight it and copy and then paste it in autocad and if there is another changes again, try to double click the one that you paste in autocad and automatically it will bring you to excel I'm not sure that would help the OP too much currently though assuming the original names wern't linked to the Excel spreadsheet? Quote Link to comment Share on other sites More sharing options...
BIGAL Posted September 7, 2011 Share Posted September 7, 2011 Theres a post here about using FIND via lisp you could write a txt file from excel then just read it line by line to do all the work Basicly you need a lisp that finds a piece of text and changes it check out LEE-MAC.com he has a good text find and replace may do what you want. Quote Link to comment Share on other sites More sharing options...
Xyclo Posted May 12, 2012 Share Posted May 12, 2012 I also having the same problem. Ive tried too look every thread, but it seems I can't find it. Can anyone give me the thread number or link? It is not a simple copying of excel table but using the data inside the table or the getting the value of the cell , and using these values to represent as text in autocad. Quote Link to comment Share on other sites More sharing options...
Dadgad Posted May 12, 2012 Share Posted May 12, 2012 Welcome to the forum. When you find yourself looking for smart solutions, try http://www.lee-mac.com/index.html where there is a very good chance you may find a tool to help you, as have so many before you. Thanks Lee! Barring finding what you need there, there are plenty of OTHER very knowledgeable and helpful folks (the lisperati) on the forum, who are always looking for somebody to help with a bit of code, and to show off their chops. Thanks guys (you know who you are)! Quote Link to comment Share on other sites More sharing options...
Xyclo Posted May 12, 2012 Share Posted May 12, 2012 Dear Sir Dadgad, thanks for your response and the link. I will share here what I will find there. ++ Respect Quote Link to comment Share on other sites More sharing options...
tapac333 Posted June 9, 2014 Share Posted June 9, 2014 Hello everybody, I'd really to find a solution to this too. It seems there's quite a bit of us looking to automate the Find/Replace function between Excel & CAD.. I have a certain grueling task of taking Chinese translations and replacing the English in the CAD files! I have a dictionary's worth of translations in an Excel file; left column English, right in Chinese. I want to basically run a process that would Find & Replace all the text in the cad file with the Chinese. To make it more efficient, I'd like to be able to add to the list in excel as I come along new translations, and alter them if they need adjustment.. Unfortunately, I'm no lisperati, and sometimes the text is within a block, within a block, within a block.. if you know what I mean.. and this is where my head starts hurting to make this automated.. I could Really Really Really use some help. 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.