+ 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 AitoCAD

    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,890

    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. 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
  2. Text and text coordinate extract to csv along polyline.
    By sanju2323 in forum AutoLISP, Visual LISP & DCL
    Replies: 24
    Last Post: 30th Jun 2015, 04:12 am
  3. xy coordinate and text extractor Lisp
    By gugamg in forum AutoLISP, Visual LISP & DCL
    Replies: 17
    Last Post: 19th Sep 2014, 07:45 pm
  4. Aitocad 2014 after long time using 2007
    By sajicor in forum AutoCAD General
    Replies: 22
    Last Post: 24th Mar 2014, 01:55 pm
  5. 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

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