+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Forum Newbie
    AutoCAD 2007
    Join Date
    Oct 2017

    Question [How to] Import .xls text with X and Y coordinate into AutoCAD

    Registered forum members do not see this ad.

    Hi there, im using AutoCAD 2017 and I have a problem.
    I used DATAEXTRACTION command to create an excel file X and Y coordinate of mtext.
    When finished edit .xls file, I want to import it into AutoCAD again but i dont know how?
    Pls help me

  2. #2
    Quantum Mechanic
    Civil 3D 2016
    Join Date
    Dec 2005


    Registered forum members do not see this ad.

    It's real easy you use the concatenation commnand in excel

    =concatenation ("text" ,b1,",",c1," 90 2.5")
    Where b1 is x and c1 is y
    Just copy the column to the autocadcommand line

    Sorry typed on IPad may need a check.

    Just look at command line for manual entry
    Last edited by BIGAL; 25th Nov 2017 at 12:17 am.
    A man who never made mistakes never made anything

Similar Threads

  1. Extract Text data at a XYZ coordinate from Autocad
    By kArThIcK hAcKeR in forum AutoLISP, Visual LISP & DCL
    Replies: 7
    Last Post: 12th Jul 2016, 12:35 pm
  2. Trouble with xyz coordinate import LISP
    By philnesterovic in forum AutoCAD 2D Drafting, Object Properties & Interface
    Replies: 2
    Last Post: 7th Apr 2016, 08:47 am
  3. Need the code for import the coordinate of text to file
    By Nad SK in forum AutoLISP, Visual LISP & DCL
    Replies: 8
    Last Post: 30th Dec 2010, 08:05 pm
  4. import text and data from excel into autocad
    By asdwer in forum AutoCAD Beginners' Area
    Replies: 2
    Last Post: 6th Jul 2010, 08:45 am
  5. import expot text from and to autocad
    By motee-z in forum AutoLISP, Visual LISP & DCL
    Replies: 6
    Last Post: 5th Apr 2007, 09:39 pm


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts