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

序号编号坐标X坐标Y高程Z
导入手薄（导入
GPS-rtk格式）
二维多段线（方法：在cad中
输入PL命令回车，框选此列直
接复制粘贴到CAD命令栏，即
可看见坐标点连成的多段线）
1现有路口12668094.5510967.611851.1481,510967.605,2
668094.476,0
510967.605,2668094.476
2现有路口22668092.6510973.611851.3932,2668092.595,
510973.609,0
510973.609,2668092.595
3现有路口32668017.2511077.51856.8213,2668017.242,
511077.499,0
511077.499,2668017.242
4现有路口42668008.6511087.531857.4084,2668008.552,
511087.531,0
511087.531,2668008.552
5现有路口52667865.3511438.261869.1675,2667865.314,
511438.264,0
511438.264,2667865.314
6现有路口62667861.8511429.711869.2576,2667861.835,
511429.714,0
511429.714,2667861.835
7现有路口72667612.2511948.491880.5937,2667612.246,
511948.494,0
511948.494,2667612.246
8现有路口82667617.5511946.31880.4478,2667617.537,
511946.298,0
511946.298,2667617.537
9现有路口92667823.6511860.811875.059,2667823.638,
511860.814,0
511860.814,2667823.638
10现有路口
10
2667827.4511859.261874.963
10,2667827.436
,511859.26,0
511859.26,2667827.436
11现有路口
11
2668109.9510971.381851.264
11,2668109.939
,510971.379,0
510971.379,2668109.939
12现有路口
12
2668111.5510965.591851.251
12,2668111.488
,510965.585,0
510965.585,2668111.488
13现有路口
13
2668114.4510909.441848.644
13,2668114.411
,510909.44,0
510909.44,2668114.411
14现有路口
14
2668113.4510902.651848.318
14,2668113.414
,510902.645,0
510902.645,2668113.414
15现有路口
15
2668105.2510873.221846.712
15,2668105.24,
510873.221,0
510873.221,2668105.24
CAD中
三维点（方法：在cad中输入PO
命令回车，框选此列直接复制粘贴到CAD命令栏，在cad菜单栏，格式中更改点样式可以不同效果
的观看）点号偏
移量
偏移后的坐标
文字高
度（可
调整字
体高
度）
point
510967.605,2668094.476,1851.0.3
510967.905,2
668094.476
0.5
point
510973.609,2668092.595,1851.0.3
510973.909,2
668092.595
0.5
point
511077.499,2668017.242,1856.0.3
511077.799,2
668017.242
0.5
point
511087.531,2668008.552,1857.0.3
511087.831,2
668008.552
0.5
point
511438.264,2667865.314,1869.0.3
511438.564,2
667865.314
0.5
point
511429.714,2667861.835,1869.0.3
511430.014,2
667861.835
0.5
point
511948.494,2667612.246,1880.0.3
511948.794,2
667612.246
0.5
point
511946.298,2667617.537,1880.0.3
511946.598,2
667617.537
0.5
point
511860.814,2667823.638,1875.0.3
511861.114,2
667823.638
0.5
point
511859.26,2667827.436,1874.90.3
511859.56,26
67827.436
0.5
point
510971.379,2668109.939,1851.0.3
510971.679,2
668109.939
0.5
point
510965.585,2668111.488,1851.0.3
510965.885,2
668111.488
0.5
point
510909.44,2668114.411,1848.60.3
510909.74,26
68114.411
0.5
point
510902.645,2668113.414,1848.0.3
510902.945,2
668113.414
0.5
point
510873.221,2668105.24,1846.70.3
510873.521,2
668105.24
0.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。