AutoCAD Lisp Problem: Transfer Titles from Excel to DWG

  • Thread starter Thread starter OffTheRecord
  • Start date Start date
  • Tags Tags
    Autocad
Click For Summary
The discussion centers on automating the process of transferring title information from an Excel file into AutoCAD DWG files using Lisp. Key points include the feasibility of accomplishing this task with minimal Lisp knowledge, the ability of a Lisp routine to read AutoCAD files without opening the GUI, and the potential for using Python or other programming languages to achieve similar results. The possibility of utilizing a CAD API is mentioned, with a suggestion to explore both commercial and free options for accessing AutoCAD functionalities. Overall, the conversation emphasizes the need for efficient input/output handling in Lisp for managing legacy AutoCAD files.
OffTheRecord
Messages
17
Reaction score
0
Hey folks. Question. Mostly about input/output in Lisp.

At work, we have thousands of old AutoCAD files that were never named properly, and thus can't be searched properly by AutoCAD Vault. The title information (drawing headers, authors, dates, etc) of all these files are currently stored in an excel file, rather than in their respective dwg files. I want to figure out some way to have a program (presumably written in Lisp, since that's the language CAD uses) take input from an excel spreadsheet (or CSV file), open up CAD dwg files, and transfer each title block into its respective CAD file.

First question: is this easy enough that I could accomplish it with minimal working knowledge of lisp?

Second question: can a lisp routine read an AutoCAD file without actually opening up the GUI? If so, how?

Third question: can the same task be accomplished using Python, or some other language?
 
Technology news on Phys.org
I don't have a ready answer, but I would start by searching for some kind of CAD API...it may have to be commercial, since CAD is not open source, but who knows, maybe there is something you can download for free for one time use.
 
Learn If you want to write code for Python Machine learning, AI Statistics/data analysis Scientific research Web application servers Some microcontrollers JavaScript/Node JS/TypeScript Web sites Web application servers C# Games (Unity) Consumer applications (Windows) Business applications C++ Games (Unreal Engine) Operating systems, device drivers Microcontrollers/embedded systems Consumer applications (Linux) Some more tips: Do not learn C++ (or any other dialect of C) as a...