Importing Points from Excel to AutoCAD/LT Using a SCRIPT File
How can I input X and Y coordinates into AutoCAD and create a SCRIPT file to produce Line, Circle, Block, Point, Donut, or Pline output in AutoCAD/LT?
What steps should I follow to input X and Y coordinates into AutoCAD and generate a SCRIPT file that produces LINE, Circle, Block, Point, Donut, or Pline output in AutoCAD/LT?
The solution is provided below.
Click here's the link to YouTube demonstration
Attached is the Excel file with VBA macro built-in and without VBA to generate the SCRIPT file.
Output for Line, Circle, Pline, Donut, Point, and Block insertion
XYZ Survey point format
Other non VBA Sample figure:
or
Attached: EXCEL_without_VBA_copy_paste_import_line_pline_point_Text_others_script_to_AutoCAD_Full_and_LT
Note :
After a script file has been created, it can be run in AutoCAD using the SCRIPT command
Running A Script File in A Drawing
Create a new drawing.
On the ribbon, click Manage tab > Applications panel > Run Script. Find.
In the Select Script File dialog box, browse to and select the Script file generated from Excel
Click Open.
Running A Script File in A Drawing
Create a new drawing.
On the ribbon, click Manage tab > Applications panel > Run Script. Find.
In the Select Script File dialog box, browse to and select the Script file generated from Excel
Click Open.
Or
Just type SCRIPT in AutoCAD/LT commandline area and browse to and select the Script file generated from Excel and Click Open.
And Other methods (For Excel without VBA)
From the script generated by the EXCEL column, just copy the script in the specified Excel column and paste it into AutoCAD/LT commandline area.
Enjoy ...
Sim
sim@acadsystems.com
Comments
Post a Comment