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

    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
    Luminous Being
    Using
    Civil 3D 2016
    Join Date
    Dec 2005
    Location
    GEELONG AUSTRALIA
    Posts
    9,901

    Default

    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

Bookmarks

Posting Permissions

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