Sunday, December 15, 2013

Import Data From Excel to AutoCAD by Using LISP






A. Create Data format in excel

1. Ist Colum Serial No.

2. 2nd Colum Chainage or X Cordinates

3. 3rd Colum offset or Y Cordinates

4. 4th Colum Reduce Level (R.L.)

5. Point Id

6. Point Name


 
 B. Data Setting

1. Select A, B, C, D, E, F, Colum

2. Right Click then mouse menu open

3. Press right click on Colum Width

 

4. Enter the value of 12

 












5. Align the values of left Side click on this button show below in image



6. Press Ctrl+S for save the file




7. File Name in simple value

8. Save as type Formatted Text (Space delimited) (*.Prn)

9. File save in short path



C. Import  in Autocad

1. Open Autocad

2. Open new file press key Ctrl+N 

3. After Open Window Press Enter

4. Press key AP Enter for Load the Lisp (as below Image)


 5. Select the lisp IMpms.lsp & IMPmnsT.lsp Click the button On Load
























6. After Click on Load Button got Massage in Left Bottom Window  Successfully loaded 2 files

7. Click the close Button

8. Type IMPMNS in AutoCAD Command Window Press Enter

9. Enter File Name F:/1.prn Press Enter



If lisp not working or got error message
Mail me for support:‐ 
sandeepk@tataprojects.com ,  srkumar.r6@gmail.com
  This Post Prepared By : Sandeep R. Kuma TATA PROJECTS LIMITED DELHI  


For more LISPs, Hatch Pattern, Line Types and Line Styles of AutoCAD Goto our Download Centre: 
 Download

2 comments :