以下源码为批量统计面积及长度输出到Excel，请大家修改仅批量统计面积输出到Excel....

注册 · 发表于 2019-9-14 09:45

(defun c:zcmj (/ d ent f i lst m2 obj pt ss txt x y)
(setq TextHeight (getdist "\n输入标注文字高度:")
Textbh (getstring "\n输入编号前缀:"))
 (defun maketext (txt pt) ; 生成文字子函数
(entmake (list '(0 . "TEXT") (cons 62 1) (cons 10 pt) (cons 40 TextHeight) (cons 1 txt) '(41 . 0.8)))
 )
 (setvar "cmdecho" 0)
 (vl-load-com)
 (setq ss (ssget) ent (entlast))
 (command ".region" ss "")
 (setq ss (ssadd) lst nil)
 (while (setq ent (entnext ent))
(if (= (cdr (assoc 0 (entget ent))) "REGION")
 (setq obj (vlax-ename->vla-object ent) pt (vlax-safearray->list (vlax-variant-value (vla-get-centroid obj)))
 m2 (rtos (/(vla-get-area obj) 1000000) 2 2) d (rtos(/ (vla-get-perimeter obj) 1000) 2 2) lst (cons (list pt m2 d) lst)
 )
)
 )
 (command ".undo" "")
 (setq lst (vl-sort lst (function (lambda (x y)(< (car (car x)) (car (car y)))))))
 (setq lst (vl-sort lst (function (lambda (x y)(> (cadr (car x)) (cadr (car y)))))))
 (setq f (getfiled "指定输出文件路径" "" "xls" 1) f (open f "a"))
 (write-line "编号\t周长(m)\t面积(m2)" f)
 (setq i 1)
 (foreach x lst
(setq pt (car x) m2 (cadr x) d (caddr x))
(maketext (strcat Textbh (itoa i)) (list (car pt) (+ (cadr pt) (* 1.2 TextHeight))))
(maketext (strcat "L=" d "m") pt)
(maketext (strcat "S=" m2 "m2") (list (car pt) (- (cadr pt) (* 1.2 TextHeight))))
(write-line (strcat (strcat Textbh (itoa i)) "\t" d "\t" m2) f)
(setq i (1+ i))
 )
 (close f)
 (princ)
)

434939575 · 发表于 2019-9-15 09:00

[code=lisp](defun c:tt (/ d ent f i lst m2 obj pt ss txt x y)
(setq TextHeight (getdist "\n输入标注文字高度:")
Textbh (getstring "\n输入编号前缀:")
)
(defun maketext (txt pt) ; 生成文字子函数
(entmake (list '(0 . "TEXT")
(cons 62 1)
(cons 10 pt)
(cons 40 TextHeight)
(cons 1 txt)
'(41 . 0.8)
)
)
)
(setvar "cmdecho" 0)
(vl-load-com)
(setq ss (ssget)
ent (entlast)
)
(command ".region" ss "")
(setq ss (ssadd)
lst nil
)
(while (setq ent (entnext ent))
(if (= (cdr (assoc 0 (entget ent))) "REGION")
(setq obj (vlax-ename->vla-object ent)
pt (vlax-safearray->list
(vlax-variant-value (vla-get-centroid obj))
)
m2 (rtos (/ (vla-get-area obj) 1000000) 2 2)
; d (rtos (/ (vla-get-perimeter obj) 1000) 2 2)
lst (cons (list pt m2 ;d
) lst)
)
)
)
(command ".undo" "")
(setq
lst (vl-sort
lst
(function (lambda (x y) (< (car (car x)) (car (car y)))))
)
)
(setq
lst (vl-sort
lst
(function (lambda (x y) (> (cadr (car x)) (cadr (car y)))))
)
)
(setq f (getfiled "指定输出文件路径" "" "xls" 1)
f (open f "a")
)
;(write-line "编号\t周长(m)\t面积(m2)" f)
(write-line "编号\t面积(m2)" f)
(setq i 1)
(foreach x lst
(setq pt (car x)
m2 (cadr x)
d (caddr x)
)
(maketext (strcat Textbh (itoa i))
(list (car pt) (+ (cadr pt) (* 1.2 TextHeight)))
)
; (maketext (strcat "L=" d "m") pt)
(maketext (strcat "S=" m2 "m2")
(list (car pt) (- (cadr pt) (* 1.2 TextHeight)))
)
(write-line
;(strcat (strcat Textbh (itoa i)) "\t" d "\t" m2)
(strcat (strcat Textbh (itoa i)) "\t" m2)
f
)
(setq i (1+ i))
)
(close f)
(princ)
)

[code=lisp](defun c:tt (/ d ent f i lst m2 obj pt ss txt x y) 
  (setq        TextHeight (getdist "\n输入标注文字高度:") 
        Textbh           (getstring "\n输入编号前缀:") 
  ) 
  (defun maketext (txt pt)                ; 生成文字子函数 
    (entmake (list '(0 . "TEXT") 
                   (cons 62 1) 
                   (cons 10 pt) 
                   (cons 40 TextHeight) 
                   (cons 1 txt) 
                   '(41 . 0.8) 
             ) 
    ) 
  ) 
  (setvar "cmdecho" 0) 
  (vl-load-com) 
  (setq        ss  (ssget) 
        ent (entlast) 
  ) 
  (command ".region" ss "") 
  (setq        ss  (ssadd) 
        lst nil 
  ) 
  (while (setq ent (entnext ent)) 
    (if        (= (cdr (assoc 0 (entget ent))) "REGION") 
      (setq obj        (vlax-ename->vla-object ent) 
            pt        (vlax-safearray->list 
                  (vlax-variant-value (vla-get-centroid obj)) 
                ) 
            m2        (rtos (/ (vla-get-area obj) 1000000) 2 2) 
          ;  d        (rtos (/ (vla-get-perimeter obj) 1000) 2 2) 
            lst        (cons (list pt m2 ;d 
                            ) lst) 
      ) 
    ) 
  ) 
  (command ".undo" "") 
  (setq 
    lst        (vl-sort 
          lst 
          (function (lambda (x y) (< (car (car x)) (car (car y))))) 
        ) 
  ) 
  (setq 
    lst        (vl-sort 
          lst 
          (function (lambda (x y) (> (cadr (car x)) (cadr (car y))))) 
        ) 
  ) 
  (setq        f (getfiled "指定输出文件路径" "" "xls" 1) 
        f (open f "a") 
  ) 
  ;(write-line "编号\t周长(m)\t面积(m2)" f) 
  (write-line "编号\t面积(m2)" f) 
  (setq i 1) 
  (foreach x lst 
    (setq pt (car x) 
          m2 (cadr x) 
          d  (caddr x) 
    ) 
    (maketext (strcat Textbh (itoa i)) 
              (list (car pt) (+ (cadr pt) (* 1.2 TextHeight))) 
    ) 
   ; (maketext (strcat "L=" d "m") pt) 
    (maketext (strcat "S=" m2 "m2") 
              (list (car pt) (- (cadr pt) (* 1.2 TextHeight))) 
    ) 
    (write-line 
      ;(strcat (strcat Textbh (itoa i)) "\t" d "\t" m2) 
      (strcat (strcat Textbh (itoa i))  "\t" m2) 
      f 
    ) 
    (setq i (1+ i)) 
  ) 
  (close f) 
  (princ) 
)

[/code]

lifuq1979 · 发表于 2019-9-15 20:50

m2 (rtos (/ (vla-get-area obj) 1000000) 2 2)即然单位是平方米为什么要/1000000
个人认为
m2 (rtos (vla-get-area obj) 2 2)

注册 · 发表于 2019-9-14 09:45

上面源码为批量统计面积及长度输出到Excel，请大咖修改仅批量统计面积输出到Excel，长度无需统计及输出，谢谢

注册 · 发表于 2019-9-15 09:47

434939575 发表于 2019-9-15 09:00
[/code]

可以了，多谢多谢

fxlt619 · 发表于 2019-9-17 10:28

有把标注文字（不炸开）提取到cad或excel里，合并排序的吗

mpk023 · 发表于 2019-9-20 09:47

为什么我用了后显示面积为000呢~~~~

664571221 · 发表于 2019-10-22 12:19

434939575 发表于 2019-9-15 09:00
[/code]

你好能否修改为批量统计长度输出到excel

434939575 · 发表于 2019-10-22 22:00

664571221 发表于 2019-10-22 12:19
你好能否修改为批量统计长度输出到excel

我对Excel这个不了解。没弄过。

liuties · 发表于 2019-11-14 10:21

学习学习感谢楼主分享

账号		自动登录	找回密码
密码			注册

[源码] 以下源码为批量统计面积及长度输出到Excel，请大家修改仅批量统计面积输出到Excel....