1、图像裁剪
命令是 imageclip
裁剪后：
原始数据采用：
点号 y x h 1 29614839.733 4892245.872 22 2 29613237.914 4892798.268 22 3 29613230.462 4892800.837 22 4 29613125.385 4892836.026 22 5 29613011.590 4892869.874 22 6 29612895.068 4892899.507 22 7 29612777.455 4892924.447 22 8 29612658.940 4892944.654 22
2、批量导入点坐标(可以带高程h)
cad中输入的命令格式为： point y,x,h
execl中格式为： ="point "&B2&","&C2 &","&D2
点号 y x h 批量点 A1 29614839.733 4892245.872 22 point 29614839.733,4892245.872,22 A2 29613237.914 4892798.268 22 point 29613237.914,4892798.268,22 A3 29613230.462 4892800.837 22 point 29613230.462,4892800.837,22 A4 29613125.385 4892836.026 22 point 29613125.385,4892836.026,22 A5 29613011.590 4892869.874 22 point 29613011.59,4892869.874,22 A6 29612895.068 4892899.507 22 point 29612895.068,4892899.507,22 A7 29612777.455 4892924.447 22 point 29612777.455,4892924.447,22 A8 29612658.940 4892944.654 22 point 29612658.94,4892944.654,22
3、批量标注坐标点号
cad中输入的命令格式为： -text j bc y,x 3 0 A1
其中X，Y尽量别和所展的点一直，统一的偏移一个量最好，这样点号就会标注的有条理了。3是字体大小，0是字体旋转角度，A1就是标注的点号。
在excel中的格式为 ="-text j bc "&B2+2&","&C2+2&" "&3&" 0 "&A2
点号 y x h 批量标注坐标点号 A1 29614839.733 4892245.872 22 -text j bc 29614841.733,4892247.872 3 0 A1 A2 29613237.914 4892798.268 22 -text j bc 29613239.914,4892800.268 3 0 A2 A3 29613230.462 4892800.837 22 -text j bc 29613232.462,4892802.837 3 0 A3 A4 29613125.385 4892836.026 22 -text j bc 29613127.385,4892838.026 3 0 A4 A5 29613011.590 4892869.874 22 -text j bc 29613013.59,4892871.874 3 0 A5 A6 29612895.068 4892899.507 22 -text j bc 29612897.068,4892901.507 3 0 A6 A7 29612777.455 4892924.447 22 -text j bc 29612779.455,4892926.447 3 0 A7 A8 29612658.940 4892944.654 22 -text j bc 29612660.94,4892946.654 3 0 A8
CAD效果如下：
4、批量展点划线
cad中输入的命令格式为：line x,y
execl中格式为： ="line "&B2&","&C2
点号 y x h 展点划线 A1 29614839.733 4892245.872 22 line 29614839.733,4892245.872 A2 29613237.914 4892798.268 22 line 29613237.914,4892798.268 A3 29613230.462 4892800.837 22 line 29613230.462,4892800.837 A4 29613125.385 4892836.026 22 line 29613125.385,4892836.026 A5 29613011.590 4892869.874 22 line 29613011.59,4892869.874 A6 29612895.068 4892899.507 22 line 29612895.068,4892899.507 A7 29612777.455 4892924.447 22 line 29612777.455,4892924.447 A8 29612658.940 4892944.654 22 line 29612658.94,4892944.654
CAD效果如下：
5、批量注释（和“3、批量标注坐标点号”差不多）
cad中输入的命令格式为：-text j ml y,x 5 0 A122
execl中格式为：="-text j ml "&B2&","&C2&" "&5&" 0 A"&A2&D2
点号 y x h 展点划线 1 29614839.733 4892245.872 22 -text j ml 29614839.733,4892245.872 5 0 A122 2 29613237.914 4892798.268 22 -text j ml 29613237.914,4892798.268 5 0 A222 3 29613230.462 4892800.837 22 -text j ml 29613230.462,4892800.837 5 0 A322 4 29613125.385 4892836.026 22 -text j ml 29613125.385,4892836.026 5 0 A422 5 29613011.590 4892869.874 22 -text j ml 29613011.59,4892869.874 5 0 A522 6 29612895.068 4892899.507 22 -text j ml 29612895.068,4892899.507 5 0 A622 7 29612777.455 4892924.447 22 -text j ml 29612777.455,4892924.447 5 0 A722 8 29612658.940 4892944.654 22 -text j ml 29612658.94,4892944.654 5 0 A822
CAD效果如下：
-text j c 4477.781,5383.034 1.5 0 161.573
-text j c 4459.429,5395.615 1.5 0 161.97
进阶 7、结合“展点划线”和“批量注释”实现坐标的输入CAD
CAD效果如下：
3、切换CAD与CASS
4、打印样式
释义：
无 不应用打印样式表 acad.ctb 默认打印样式，彩色打印 DWF Virtual Pens.ctb CAD自带的彩色打印 fill Patterns.ctb 设置前9种颜色使用前9个填充图案，所有其他颜色使用对象的填充图案 grayscale.ctb 打印时将所有颜色转换为灰度 monochrome.ctb 将所有颜色打印为黑色 screening 100%.ctb 对所有颜色使用100%墨水 screening 75%.ctb 对所有颜色使用75%墨水 screening 50%.ctb 对所有颜色使用50%墨水 screening 25%.ctb 对所有颜色使用25%墨水
参考网站：
cad批量导入坐标：https://jingyan.baidu.com/article/1876c852447bda890b1376df.html