获取点的坐标
请帮我解决那个问题。我无法用vba解决这个问题。需要12345678。图纸
需要帮助11111111。xlsx公司 如果我错了，请纠正我，但这不是你第三次发布基本相同的问题吗？我发誓我已经看到这两个文件，或者非常相似的东西，附加到另一个线程。 我需要那个问题的答案。为此，我从不计算我付出了多少努力。因此，如果你有答复给我。我使用autocad 2007时，我无法理解这一点。请帮帮我。 请表现出一些耐心。使用同一个问题创建多个线程只会在论坛成员开始回复时导致混乱，因为所有回复可能不在一个线程中。你明白吗？
也许VBA Express知识库中发布的有关AutoCAD、点和VBA的帖子对您有一定的帮助。
http://www.vbaexpress.com/forum/showthread.php?18957-已解决-VBA和-AutoCAD-reading-points-from-a-txt-file 这将使一个CSV文件从excel看在2004年的日期！
; SETOUTBOX.LSP draw setout details boxed co-ord list
; 29/9/04 by alan h
(setvar "menuecho" 0)
(setvar "SNAPMODE" 0)
(SETQ OLDSNAP (GETVAR "OSMODE"))
(setvar "OSMODE" 0)
(defun xyz ()
(setq ans "")
(setq char_found "")
(while (/= char_found ",")
(setq char_found (substr new_line x 1))
(setq x (+ x 1))
(setq ans (strcat ans char_found))
) ;end while
) ;end defun
(setq setsc (/ (getreal "\nEnter Dwg scale 1: ") 1000.0))
(setq stpt (getpoint "\nPick top left point for details "))
(setq xyzfiles (getfiled "\nENTER CO-ORD File name" "" "" 4))
(setq fopen (open xyzfiles "R"))
(command "zoom" "E")
(command "zoom" "c" stpt (* setsc 100.0))
(setq pt1 stpt)
(setq txtht (* 2.5 setsc)); 2.5mm HIGH LETTERING
(setq num 1)
(setq llen (* 84.0 setsc))
(setq ydiff (* 4.5 setsc)); 4.5mm line spacing
(setq stptx (car stpt))
(setq stpty (cadr stpt))
(setq txtpt (list (+ stptx (* 42.0 setsc)) (+ stpty (* 2.0 setsc))))
(command "text" "BC" txtpt txtht "" "xxxxx")
(setq txtpt (list (+ stptx (* 42.0 setsc)) (+ stpty (* 7.0 setsc))))
(command "text" "BC" txtpt txtht "" "%%uSETOUT DETAIL")
(setq pt2 (polar stpt 0.0 llen))
(command "line" stpt pt2 "") ;draw horizontal line
(setq pt1 (polar stpt 4.7124 (* 5.75 setsc)))
(setq txtpt (polar pt1 0.0 (* 9.0 setsc)))
(command "text" "BC" txtpt (* 3.5 setsc) "" "POINT")
(setq txtpt (polar pt1 0.0 (* 34.0 setsc)))
(command "text" "BC" txtpt (* 3.5 setsc) "" "EASTING")
(setq txtpt (polar pt1 0.0 (* 67.0 setsc)))
(command "text" "BC" txtpt (* 3.5 setsc) "" " NORTHING ")
(setq pt1 (polar stpt 4.7124 (* 8.0 setsc)))
(setq pt2 (polar pt1 0.0 llen))
(command "line" pt1 pt2 "") ;draw horizontal line
(setq pt1 (polar pt1 4.7124 (* 1.0 setsc)))
(setq pt2 (polar pt1 0.0 llen))
(command "line" pt1 pt2 "") ;draw horizontal line below above
(setq pt1 (polar pt1 4.7124 (* 1.0 setsc)))
(setq pt2 (polar pt1 0.0 llen))
(command "line" pt1 pt2 "") ;draw horizontal line below above
(setq pt3 pt1) ; sets pt to last line position
;(setq pt5 (polar pt3 1.5708 (* 1.0 setsc))) ; 1 mm above line
(setq pt5 pt3) ; 0.5 mm above line
(SETQ XX 1)
(while (setq new_line (read-line fopen))
(PRINC XX)
(setq x 1)
(setq y 5)
(xyz)
(setq ptno ans) ;pull ptno out
(xyz)
(setq easting ans)
(xyz)
(setq northing ans)
(setq pt3 (polar pt3 4.7124 ydiff))
(setq pt4 (polar pt3 0.0 llen))
(command "line" pt3 pt4 "")
(setq pt5 (polar pt5 4.7124 ydiff))
(setq pt6 (polar pt5 0.0 (* 8.0 setsc)))
(setq pt7 (polar pt5 0.0 (* 28.0 setsc)))
(setq pt8 (polar pt5 0.0 (* 58.0 setsc)))
(command "text" "BL" pt6 txtht "" ptno)
(command "text" "BL" pt7 txtht "" EASTING)
(command "text" "BL" pt8 txtht "" NORTHING)
(SETQ XX (+ XX 1))
) ; end while
(command "line" stpt pt3 "")
(setq pt3 (polar pt3 0.0 (* 18.0 setsc)))
(setq stpt (polar stpt 0.0 (* 18.0 setsc)))
(command "line" stpt pt3 "")
(setq pt3 (polar pt3 0.0 (* 33.0 setsc)))
(setq stpt (polar stpt 0.0 (* 33.0 setsc)))
(command "line" stpt pt3 "")
(setq pt3 (polar pt3 0.0 (* 33.0 setsc)))
(setq stpt (polar stpt 0.0 (* 33.0 setsc)))
(command "line" stpt pt3 "")
(princ setsc )
(setq pt1nil
pt2nil
pt3nil
pt4nil
pt5nil
pt6nil
pt7nil
pt8nil
stpt nil
ansnil
SETSC NIL
)
(SETVAR "OSMODE" OLDSNAP)
(princ)
页:
[1]