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

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

(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:09

(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)
)

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

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

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

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

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

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

可以了，多谢多谢

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

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

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

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

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

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

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

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

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

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

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

学习学习感谢楼主分享

页: [1] 2

明经CAD社区's Archiver

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