I have a need for an Acad 2014 LISP that will read Excel and whats in column A will be replaced with whats in column B of the same row, about 3200 rows of it. Anyone ever found anything like that? I found something but it doesnt read from or copy from excel. Help please?!?
Evan
Solved! Go to Solution.
Solved by Lee_Mac. Go to Solution.
No just text, they are part numbers from old the manufacturer in column A that need to be current manufaturer part/model number in column B.
What is the entity type in AutoCAD? Table? Mtexts with lines? Texts? Blocks?
Can you upload a sample drawing with a sample Excel file?
You could use my BFind program for this task.
As it stands, the current version of the program doesn't allow you to import find & replace pairs from an external file, however, you can perform the following steps to import the data into the program:
Start the program, enter a few find & replace entries, and save the list using an arbitrary reference. Then exit the program and type at the AutoCAD command-line:
(findfile "LMAC_BFind_SavedSearches_V2-0.txt")
This will give the location of the file that the program uses to store the find & replace pairs.
I would suggest that you first save a few different search references with the program (using the 'Save' button) and you will then easily see the required format of this text file. The file may then be edited manually to add search/replace items from your spreadsheet, providing that you keep to the same format so that it may be read by the program in the expected format. As a tip, I would suggest first saving your Excel spreadsheet as a tab-delimited text file.
I hope this helps,
Lee
AWESOME!! That worked great! Thank you very much!
Glad to hear it evan - you're welcome!
AutoReplaceCAD from kdmsoft solved the problem, I do not give a link, you will find it yourself in Google
Can't find what you're looking for? Ask the community or share your knowledge.