Expected duration: 3 - 4 weeks I need an AutoLISP program that exports cell values from an Excel file and transfers to a given attribute field in AutoCAD.
Your AutoLISP program will be integrated to the AutoCAD ribbon panel (no need to create) and will be launched manually by the users. When it runs: 1. it has to search for the Excel file with a fixed name in the same folder of the AutoCAD file or maximum two folder levels up. If no file found, it exits. 2. in the Excel file the first two columns identify the .dwg file and the layout name, your program has to identify the matching row(s) of the active .dwg file from which it has been launched. Number of rows may vary. 3. the top row identifies the attribute tags, your program has to identify them and extract the relevant cell value. Number of columns may vary. 4. in AutoCAD it has to search for the layout and attribute tag and paste the cell value. If no attribute found, it jumps to the next one. It repeats with all layouts within the .dwg file and attribute tags. 5. After finishing, it displays a message in the AutoCAD command line.
More details and sample files are provided after winning the job, please find pdf attached. I am aware of the existing similar solutions, but for copyright reasons I needd my own program. Do not copy-paste the existing program codes. I need a txt file with the code.
Please only apply for this job after uderstanding the task and if you are sure you can complete the task. The candidate will not be chosen based on the application speed.