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

Post a Comment

7 Comments

  1. Great article. I learned some new things. Thanks for sharing.

    2 and 3 bhk flats in nungambakkam

    ReplyDelete
  2. As far as me being a member here, I wasn’t aware that I was a member for any days, actually. When the article was published I received a notification, so that I could participate in the discussion of the post, That would explain me stumbuling upon this post. But we’re certainly all members in the world of ideas. converting drawings

    ReplyDelete
  3. Wow, suprisingly I never knew this. Keep up with good posts. final cut pro x plugins 

    ReplyDelete
  4. Learn Autocad from the best institute that is High technologies solutions with 100% placement help. Trainers at HTS are friendly, cooperative and subject specialist having more than 5 years of experience.For free demo class Call +919311002620 or visit our website.
    autocad training institute in Delhi
    autocad training institute in Noida

    ReplyDelete
  5. You've posted a very informative post here. This article provided me with some useful knowledge. Thank you for sharing that. Keep up the good work. singapore import data

    ReplyDelete