Visual LISP, AutoLISP and General Customization

Reply
Distinguished Contributor
Posts: 645
Registered: ‎03-09-2007
Message 1 of 3 (395 Views)
Accepted Solution

what'S wrong with this lisp to import excel x y to cad

395 Views, 2 Replies
02-21-2012 11:47 AM

i attached a lsp with and excel

the lsp does creat circles with diameter of 5 related to imported points from excel

i realsed that it is able to get the first column but can get the coordinate from the second one

                (setq posX (atof (substr line 1 nPos)))  (this is ok)
                (setq posY (atof (substr line (1+ nPos)))) (not this one)

 

*Expert Elite*
Kent1Cooper
Posts: 4,968
Registered: ‎09-13-2004
Message 2 of 3 (388 Views)

Re: what'S wrong with this lisp to import excel x y to cad

02-21-2012 12:01 PM in reply to: syria89

syria89 wrote:

....

the lsp does creat circles with diameter of 5 related to imported points from excel

i realsed that it is able to get the first column but can get the coordinate from the second one

                (setq posX (atof (substr line 1 nPos)))  (this is ok)
                (setq posY (atof (substr line (1+ nPos)))) (not this one)

 


Given this line [the first one]:
 

288390.6;5052934

 

and that nPos has been set by this:

 

(setq nPos (vl-string-position (ascii ";") line))

 

then nPos will be 8, and posX will be 288390.6.  But you want posY to be read starting at the tenth position, not the ninth, because (substr) counts the first character as 1, whereas (vl-string-position counts it as 0.  Try:
 

                (setq posY (atof (substr line (+ nPos 2))))

Kent Cooper
Distinguished Contributor
Posts: 645
Registered: ‎03-09-2007
Message 3 of 3 (383 Views)

Re: what'S wrong with this lisp to import excel x y to cad

02-21-2012 12:15 PM in reply to: Kent1Cooper

A BIG THANKS

:robothappy:

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Welcome to the new Autodesk Community!
If this is your first visit, click here to get started and make the most of the Community. Let us know what you think of the new experience in the Community Feedback Forum.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community