CAD中借用EXCEL把测量坐标直接展点的方法(展点成多段线、三维点、点号+编号、点号+高程 )

序号编号坐标X坐标Y高程Z

导入手薄（导入

GPS-rtk格式）

二维多段线（方法：在cad中

输入PL命令回车，框选此列直

接复制粘贴到CAD命令栏，即

可看见坐标点连成的多段线）

1现有路口12668094.5510967.611851.1481,510967.605,26680

510967.605,2668094.476

2现有路口22668092.6510973.611851.3932,2668092.595,5109

510973.609,2668092.595

3现有路口32668017.2511077.51856.8213,2668017.242,5110

511077.499,2668017.242

4现有路口42668008.6511087.531857.4084,2668008.552,5110

511087.531,2668008.552

5现有路口52667865.3511438.261869.1675,2667865.314,5114

511438.264,2667865.314

6现有路口62667861.8511429.711869.2576,2667861.835,5114

511429.714,2667861.835

7现有路口72667612.2511948.491880.5937,2667612.246,5119

511948.494,2667612.246

8现有路口82667617.5511946.31880.4478,2667617.537,5119

511946.298,2667617.537

9现有路口92667823.6511860.811875.059,2667823.638,5118

511860.814,2667823.638

10现有路口102667827.4511859.261874.96310,2667827.436,511

511859.26,2667827.436

11现有路口112668109.9510971.381851.26411,2668109.939,510

510971.379,2668109.939

12现有路口122668111.5510965.591851.25112,2668111.488,510

510965.585,2668111.488

13现有路口132668114.4510909.441848.64413,2668114.411,510

510909.44,2668114.411

14现有路口142668113.4510902.651848.31814,2668113.414,510

510902.645,2668113.414

15现有路口152668105.2510873.221846.71215,2668105.24,5108

510873.221,2668105.24

CAD中

三维点（方法：在cad中输入PO

命令回车，框选此列直接复制粘贴到CAD命令栏，在cad菜单栏，格式中更改点样式可以不同效果

的观看）点号偏

移量

偏移后的坐标

文字高

度（可

调整字

体高

度）

point 510967.605,2668094.476,180.3510967.905,26680.5

point 510973.609,2668092.595,180.3510973.909,26680.5

point 511077.499,2668017.242,180.3511077.799,26680.5

point 511087.531,2668008.552,180.3511087.831,26680.5

point 511438.264,2667865.314,180.3511438.564,26670.5

point 511429.714,2667861.835,180.3511430.014,26670.5

point 511948.494,2667612.246,180.3511948.794,26670.5

point 511946.298,2667617.537,180.3511946.598,26670.5

point 511860.814,2667823.638,180.3511861.114,26670.5

point 511859.26,2667827.436,1870.3511859.56,266780.5

point 510971.379,2668109.939,180.3510971.679,26680.5

point 510965.585,2668111.488,180.3510965.885,26680.5

point 510909.44,2668114.411,1840.3510909.74,266810.5

point 510902.645,2668113.414,180.3510902.945,26680.5

point 510873.221,2668105.24,1840.3510873.521,26680.5

CAD中借用EXCEL把测量坐标直接展点的方法（展点成多段线、三维点、

维点、编号、编号+高程 ）

编号（方法：框选此列直接复制粘贴到CAD命令

栏）

-text 510967.905,2668094.476 0.5 0 现有路口1 -text 510973.909,2668092.595 0.5 0 现有路口2 -text 511077.799,2668017.242 0.5 0 现有路口3 -text 511087.831,2668008.552 0.5 0 现有路口4 -text 511438.564,2667865.314 0.5 0 现有路口5 -text 511430.014,2667861.835 0.5 0 现有路口6 -text 511948.794,2667612.246 0.5 0 现有路口7 -text 511946.598,2667617.537 0.5 0 现有路口8 -text 511861.114,2667823.638 0.5 0 现有路口9 -text 511859.56,2667827.436 0.5 0 现有路口10 -text 510971.679,2668109.939 0.5 0 现有路口11 -text 510965.885,2668111.488 0.5 0 现有路口12 -text 510909.74,2668114.411 0.5 0 现有路口13 -text 510902.945,2668113.414 0.5 0 现有路口14 -text 510873.521,2668105.24 0.5 0 现有路口15

编号+高程（方法：框选此列直接复制粘贴到CAD命令栏）

-text 510967.905,2668094.476 0.5 0 现有路口1 1851.148 -text 510973.909,2668092.595 0.5 0 现有路口2 1851.393 -text 511077.799,2668017.242 0.5 0 现有路口3 1856.821 -text 511087.831,2668008.552 0.5 0 现有路口4 1857.408 -text 511438.564,2667865.314 0.5 0 现有路口5 1869.167 -text 511430.014,2667861.835 0.5 0 现有路口6 1869.257 -text 511948.794,2667612.246 0.5 0 现有路口7 1880.593 -text 511946.598,2667617.537 0.5 0 现有路口8 1880.447 -text 511861.114,2667823.638 0.5 0 现有路口9 1875.05

-text 511859.56,2667827.436 0.5 0 现有路口10 1874.963 -text 510971.679,2668109.939 0.5 0 现有路口11 1851.264 -text 510965.885,2668111.488 0.5 0 现有路口12 1851.251 -text 510909.74,2668114.411 0.5 0 现有路口13 1848.644 -text 510902.945,2668113.414 0.5 0 现有路口14 1848.318 -text 510873.521,2668105.24 0.5 0 现有路口15 1846.712