坐标点号导入CAD
512111.424 512105.676 512099.928 512095.617 512090.587 512108.296 512106.859 512101.111 512095.363 512091.052 512086.022
_point , -text j ml 0.07,-0.5 0.6 0 _point 522608.7733,3549556.8495 -text j ml 522608.8433,3549556.3495 0.6 0 CPI061 _point 518893.2354,3548456.475 -text j ml 518893.3054,3548455.975 0.6 0 CPI062 _point 514850.703,3547032.3394 -text j ml 514850.773,3547031.8394 0.6 0 CPI063 _point 510869.0471,3545997.0529 -text j ml 510869.1171,3545996.5529 0.6 0 CPI064 _point 506992.4626,3545901.611 -text j ml 506992.5326,3545901.111 0.6 0 CPI065 _point 503653.7007,3545471.3946 -text j ml 503653.7707,3545470.8946 0.6 0 CPI066B _point 498911.5647,3544348.1183 -text j ml 498911.6347,3544347.6183 0.6 0 CPI067B _point 495132.762,3546697.9152 -text j ml 495132.832,3546697.4152 0.6 0 CPI068B _point 490851.1921,3546741.9661 -text j ml 490851.2621,3546741.4661 0.6 0 CPI069B _point 486659.0252,3547015.7457 -text j ml 486659.0952,3547015.2457 0.6 0 CPI070B _point 482410.204,3546934.3793 -text j ml 482410.274,3546933.8793 0.6 0 CPI071B _point 479822.0124,3544501.9794 -text j ml 479822.0824,3544501.4794 0.6 0 CPI072B _point 477369.0272,3541183.1327 -text j ml 477369.0972,3541182.6327 0.6 0 CPI073B _point 474191.8185,3538965.8551 -text j ml 474191.8885,3538965.3551 0.6 0 CPI074B _point 470167.1149,3538765.1117 -text j ml 470167.1849,3538764.6117 0.6 0 CPI075B _point 468141.2736,3539459.9625 -text j ml 468141.3436,3539459.4625 0.6 0 CPI076B _point 468301.8114,3540133.3523 -text j ml 468301.8814,3540132.8523 0.6 0 CPI077B _point 465779.0646,3539399.7635 -text j ml 465779.1346,3539399.2635 0.6 0 CPI078B _point 466060.905,3538672.8386 -text j ml 466060.975,3538672.3386 0.6 0 CPI079B _point 512104.492273532,3230752.47763982 -text j ml 512104.562273532,3230751.97763982 0.6 0 B10 _point 512100.1811892,3230760.37792791 -text j ml 512100.2511892,3230759.87792791 0.6 0 B11 _point 512095.151590813,3230769.59493068 -text j ml 512095.221590813,3230769.09493068 0.6 0 B12 _point 512112.860915632,3230726.28592683 -text j ml 512112.930915632,3230725.78592683 0.6 0 B13
_point 512111.423887522,3230728.9193562 -text j ml 512111.493887522,3230728.4193562 0.6 0 B14 _point 512105.675775079,3230739.45307365 -text j ml 512105.745775079,3230738.95307365 0.6 0 B15 _point 512099.927662637,3230749.9867911 -text j ml 512099.997662637,3230749.4867911 0.6 0 B16 _point 512095.616578305,3230757.88707919 -text j ml 512095.686578305,3230757.38707919 0.6 0 B17 _point 512090.586979918,3230767.10408196 -text j ml 512090.656979918,3230766.60408196 0.6 0 B18 _point 512108.296304737,3230723.79507811 -text j ml 512108.366304737,3230723.29507811 0.6 0 B19 _point 512106.859276626,3230726.42850747 -text j ml 512106.929276626,3230725.92850747 0.6 0 B20 _point 512101.111164183,3230736.96222492 -text j ml 512101.181164183,3230736.46222492 0.6 0 B21 _point 512095.363051741,3230747.49594237 -text j ml 512095.433051741,3230746.99594237 0.6 0 B22 _point 512091.051967409,3230755.39623046 -text j ml 512091.121967409,3230754.89623046 0.6 0 B23 _point 512086.022369022,3230764.61323323 -text j ml 512086.092369022,3230764.11323323 0.6 0 B24 _point , -text j ml 0.07,-0.5 0.6 0 _point , -text j ml 0.07,-0.5 0.6 0 _point , -text j ml 0.07,-0.5 0.6 0 _point , -text j ml 0.07,-0.5 0.6 0 _point , -text j ml 0.07,-0.5 0.6 0 _point , -text j ml 0.07,-0.5 0.6 0 _point , -text j ml 0.07,-0.5 0.6 0 _point , -text j ml 0.07,-0.5 0.6 0 _point , -text j ml 0.07,-0.5 0.6 0 _point , -text j ml 0.07,-0.5 0.6 0 _point , -text j ml 0.07,-0.5 0.6 0 _point , -text j ml 0.07,-0.5 0.6 0 _point , -text j ml 0.07,-0.5 0.6 0 _point , -text j ml 0.07,-0.5 0.6 0 _point , -text j ml 0.07,-0.5 0.6 0 _point , -text j ml 0.07,-0.5 0.6 0 _point , -text j ml 0.07,-0.5 0.6 0 _point , -text j ml 0.07,-0.5 0.6 0 _point , -text j ml 0.07,-0.5 0.6 0 _point , -text j ml 0.07,-0.5 0.6 0 _point , -text j ml 0.07,-0.5 0.6 0 _point , -text j ml 0.07,-0.5 0.6 0 _point , -text j ml 0.07,-0.5 0.6 0 _point , -text j ml 0.07,-0.5 0.6 0 _point , -text j ml 0.07,-0.5 0.6 0
B10 3230752.478
B11 3230760.378
B12 3230769.595
B13 3230726.286
522608.773 518893.235 514850.703 510869.047 506992.463 503653.701 498911.565 495132.762 490851.192 486659.025 482410.204 479822.012 477369.027 474191.819 470167.115 468141.274 468301.811 465779.065 466060.905 512104.492 512100.181 512095.152 512112.861
CAD批量导入坐标点及点编号方法
CAD批量导入坐标点及点编号方法
CAD批量导入坐标点及点编号
先将EXCEL中坐标，按照如图所示的填好：
序号根据自己的需求填写，支持文字。
point后面需要加空格，
text后面需要加空格，
100前后都需要加空格，100为文字高度，可以调整
0后面需要加空格，0为文字旋转角度，可以调整
空格的意思执行该命令，不能少否则会出错
（C3+50，D3+50）是输入编号的位置，相当于x y 在原来的点的位置各偏移了50 ，这个数字可以修改，也可以为负值
将E列文字复制到文本，如图所示：
1、修改文本文件的后缀即文件格式，改为scr格式。
2、在CAD工具里面运行脚本文件，即SCR文件，即可输入点。
3、同样的方法可以对编号进行炒作。
4、。
坐标导入cad格式
点号x y54632174.901501153.61864632179.252501156.50394632255.353501850.281104632252.173501863.619144632252.576501867.724394632082.716502613.558404632068.918502671.079454632008.002502934.801464632002.232502976.086474631945.757503351.733484632042.612503421.668 494632252.002503563.675504632287.267503587.344514632423.879503679.144544632508.371503737.963554633297.878504277.721574633398.339504352.048584634042.084504746.284614634222.422505118.918624634466.529505540.322634634714.829505761.717644634738.729505784.832664634821.732505856.886674634991.238506079.497724635179.998506272.002734635186.976506314.487774637316.904506417.685784635402.025506489.434814635475.807506547.339824635755.523506779.863874636017.811507036.274874636017.811507036.274884636266.035507373.648894636327.354507431.571954636585.762507587.561954636585.762507587.561964636750.037507702.592974636772.856507716.9561084637179.151508209.631 1084637179.151508209.631 1094637728.817508667.541 1114638688.137509388.998 1114638688.137509388.998 1124638911.104509654.933 1254639132.361510007.681 1254639132.261510007.681 1264639764.235511185.217 1274639961.435511281.192 1284640413.826511216.396 1294640444.421511214.285 1304640620.376511214.156 1474641115.896511642.141 1474641115.896511642.141 1484641196.328511732.326 1634641510.557511927.674 1654641955.451512116.987 1664641972.882512122.175 1694643658.081513124.041 1744643582.604513285.492 1764643425.204513446.771 1814643312.649513573.762 1824643284.776513610.812 1834643281.619513616.516 1844643182.519513725.439 1854643174.929513729.761 1864643161.652513743.111 1874642932.301513953.645 1904642899.945513987.411 1914642764.962514113.161 1994642590.763514272.384 1994642590.763514272.384 1994642590.763514272.384 2004642138.738514743.782 2014642164.809514782.642 2024642621.305515071.671 2034642636.984515081.923 2124643007.004515319.2852174643173.553515429.818 2184643233.397515463.182 2194643409.274515621.261 2284643779.727515834.553 2364644021.036515914.953 2374644250.772515999.405 2394644284.743516004.064 2404644356.885516015.532 2424644617.597516070.827 2434644662.081516075.735 2444644825.099516104.439 2544645247.116516200.879 2554645479.888516297.279 2664645894.009516441.837 2674645904.569516430.363 2684646108.579516265.991 2714646535.082516671.166 2774646725.723516751.411 2794647073.644516950.588 2804647080.434516959.009 2824647196.201517076.291 2834647202.103517079.892 2844647405.651517316.689 2924647492.872517595.146 2944647559.724517903.082 2954647904.686518027.962 3064648104.191521649.439 3144651783.281524392.648 3154654587.771525152.011 3154654587.771525152.011 3164654602.692525174.227 3164654602.692525174.227 3184656048.996528966.142 3194656068.159529161.893 3234656089.011529357.106 3254656280.008530323.754 3274656316.631530452.775 3474656467.035531195.8663474656467.035531195.866 3474656467.035531195.866 3484665886.529544637.126 3554663675.354543462.566 3564663656.069543448.671 3584663631.978543432.299 3594663610.825543428.681 3694661663.457540426.373 3704661658.451540416.014 3714660955.621539428.848 3754660167.829538482.616 3764660164.743538477.442 3774660116.949538414.601 3784660113.652538410.322 3794660103.247538398.013 3804660101.819538391.926 3814660038.714538314.296 3854660003.899538263.223 3874659900.241538046.705 3914659864.838537969.793 3934659716.424537616.306 3944659714.414537612.819 3964659601.392537339.103 3974659598.791537332.013 3994659438.479536942.391 4004659435.805536938.533 4074658514.409535302.547 4084658510.169535302.093 4154657201.843533211.102 4164666035.854544713.824 4184666050.744544794.398 4194666733.808545904.923 4214667283.793546497.511 4224667286.321546498.493 4234667979.555547010.051 4244667988.265548944.104 4254667977.111548904.265 4254667988.265548944.104 4254667988.265548944.1044264669457.701549885.945 4324669691.656550036.716 4334669732.282550061.556 4344669740.811550067.987 4354670594.118550579.477 4364670600.267550581.549 4374670621.302550586.915 4484671016.421550314.177 4494671589.652550431.572 4564671784.397550541.849 4574671800.754550593.114 4714671698.999551176.748 4734671685.828551241.756 4744671694.481551247.364 4754671702.186551253.948 4774671923.405551376.091 4784671930.395551380.331 4804672939.184551990.305 4814672944.381551992.521 4824672951.459551997.617 4834672958.286552002.748 4844673127.441552104.123 4854673539.051552348.336 4854673539.051552348.336 4864673550.045552356.806 4874673582.146552376.628 4894673640.869552414.748 4904673736.585552475.218 4994674031.471552654.819 5004674096.212552693.157 5014674104.239552699.599 5024674679.371553049.686 5034674684.312553053.137 5044674688.574553055.184 5054674698.801553062.406 5084665901.874545619.684 5094665899.747545623.321 5104665246.222547677.179 5134664663.981548441.4515144664659.209548445.179 5184663933.177549357.567 5204663357.081550246.094 5244661140.999552193.952 5254661146.805552319.109 5254661146.805552319.109 5254661146.805552319.109 5264661074.458552361.171 5274661032.377553002.915 5284661032.714553006.666 5294661026.705553079.581 5304661027.569553082.421 5314661024.621553115.594 5324661022.381553151.366 5334661309.332553936.041 5364661327.816553979.616 5374661471.126554182.499 5394662815.169560609.575 5414662820.558560669.461 5424662796.177561243.185 5434662795.471561245.675 5444662775.531561495.981 5534662753.481561752.641 5544662726.121562091.455 5664662687.238562565.838 5674662648.881562903.633 5714662638.051563011.118 5724662593.777563590.818 5744662592.151563659.711 5764662578.998563796.467 5814662443.815563965.225 5824662283.253564153.206 5864662222.916564223.827 5874661817.571564703.949 5914661703.427564839.767 5924661679.377564867.347line 501153.618,4632174.901 line 501156.503,4632179.252 line 501850.281,4632255.353 line 501863.619,4632252.173 line 501867.724,4632252.576 line 502613.558,4632082.716 line 502671.079,4632068.918 line 502934.801,4632008.002 line 502976.086,4632002.232 line 503351.733,4631945.757 line 503421.668,4632042.612 line 503563.675,4632252.002 line 503587.344,4632287.267 line 503679.144,4632423.879 line 503737.963,4632508.371 line 504277.721,4633297.878 line 504352.048,4633398.339 line 504746.284,4634042.084 line 505118.918,4634222.422 line 505540.322,4634466.529 line 505761.717,4634714.829 line 505784.832,4634738.729 line 505856.886,4634821.732 line 506079.497,4634991.238 line 506272.002,4635179.998 line 506314.487,4635186.976 line 506417.685,4637316.904 line 506489.434,4635402.025 line 506547.339,4635475.807 line 506779.863,4635755.523 line 507036.274,4636017.811 line 507036.274,4636017.811 line 507373.648,4636266.035 line 507431.571,4636327.354 line 507587.561,4636585.762 line 507587.561,4636585.762 line 507702.592,4636750.037 line 507716.956,4636772.856line 508209.631,4637179.151 line 508667.541,4637728.817 line 509388.998,4638688.137 line 509388.998,4638688.137 line 509654.933,4638911.104 line 510007.681,4639132.361 line 510007.681,4639132.261 line 511185.217,4639764.235 line 511281.192,4639961.435 line 511216.396,4640413.826 line 511214.285,4640444.421 line 511214.156,4640620.376 line 511642.141,4641115.896 line 511642.141,4641115.896 line 511732.326,4641196.328 line 511927.674,4641510.557 line 512116.987,4641955.451 line 512122.175,4641972.882 line 513124.041,4643658.081 line 513285.492,4643582.604 line 513446.771,4643425.204 line 513573.762,4643312.649 line 513610.812,4643284.776 line 513616.516,4643281.619 line 513725.439,4643182.519 line 513729.761,4643174.929 line 513743.111,4643161.652 line 513953.645,4642932.301 line 513987.411,4642899.945 line 514113.161,4642764.962 line 514272.384,4642590.763 line 514272.384,4642590.763 line 514272.384,4642590.763 line 514743.782,4642138.738 line 514782.642,4642164.809 line 515071.671,4642621.305 line 515081.923,4642636.984 line 515319.285,4643007.004line 515463.182,4643233.397 line 515621.261,4643409.274 line 515834.553,4643779.727 line 515914.953,4644021.036 line 515999.405,4644250.772 line 516004.064,4644284.743 line 516015.532,4644356.885 line 516070.827,4644617.597 line 516075.735,4644662.081 line 516104.439,4644825.099 line 516200.879,4645247.116 line 516297.279,4645479.888 line 516441.837,4645894.009 line 516430.363,4645904.569 line 516265.991,4646108.579 line 516671.166,4646535.082 line 516751.411,4646725.723 line 516950.588,4647073.644 line 516959.009,4647080.434 line 517076.291,4647196.201 line 517079.892,4647202.103 line 517316.689,4647405.651 line 517595.146,4647492.872 line 517903.082,4647559.724 line 518027.962,4647904.686 line 521649.439,4648104.191 line 524392.648,4651783.281 line 525152.011,4654587.771 line 525152.011,4654587.771 line 525174.227,4654602.692 line 525174.227,4654602.692 line 528966.142,4656048.996 line 529161.893,4656068.159 line 529357.106,4656089.011 line 530323.754,4656280.008 line 530452.775,4656316.631 line 531195.866,4656467.035line 531195.866,4656467.035 line 531195.866,4656467.035 line 544637.126,4665886.529 line 543462.566,4663675.354 line 543448.671,4663656.069 line 543432.299,4663631.978 line 543428.681,4663610.825 line 540426.373,4661663.457 line 540416.014,4661658.451 line 539428.848,4660955.621 line 538482.616,4660167.829 line 538477.442,4660164.743 line 538414.601,4660116.949 line 538410.322,4660113.652 line 538398.013,4660103.247 line 538391.926,4660101.819 line 538314.296,4660038.714 line 538263.223,4660003.899 line 538046.705,4659900.241 line 537969.793,4659864.838 line 537616.306,4659716.424 line 537612.819,4659714.414 line 537339.103,4659601.392 line 537332.013,4659598.791 line 536942.391,4659438.479 line 536938.533,4659435.805 line 535302.547,4658514.409 line 535302.093,4658510.169 line 533211.102,4657201.843 line 544713.824,4666035.854 line 544794.398,4666050.744 line 545904.923,4666733.808 line 546497.511,4667283.793 line 546498.493,4667286.321 line 547010.051,4667979.555 line 548944.104,4667988.265 line 548904.265,4667977.111 line 548944.104,4667988.265 line 548944.104,4667988.265line 550036.716,4669691.656 line 550061.556,4669732.282 line 550067.987,4669740.811 line 550579.477,4670594.118 line 550581.549,4670600.267 line 550586.915,4670621.302 line 550314.177,4671016.421 line 550431.572,4671589.652 line 550541.849,4671784.397 line 550593.114,4671800.754 line 551176.748,4671698.999 line 551241.756,4671685.828 line 551247.364,4671694.481 line 551253.948,4671702.186 line 551376.091,4671923.405 line 551380.331,4671930.395 line 551990.305,4672939.184 line 551992.521,4672944.381 line 551997.617,4672951.459 line 552002.748,4672958.286 line 552104.123,4673127.441 line 552348.336,4673539.051 line 552348.336,4673539.051 line 552356.806,4673550.045 line 552376.628,4673582.146 line 552414.748,4673640.869 line 552475.218,4673736.585 line 552654.819,4674031.471 line 552693.157,4674096.212 line 552699.599,4674104.239 line 553049.686,4674679.371 line 553053.137,4674684.312 line 553055.184,4674688.574 line 553062.406,4674698.801 line 545619.684,4665901.874 line 545623.321,4665899.747 line 547677.179,4665246.222 line 548441.451,4664663.981line 549357.567,4663933.177 line 550246.094,4663357.081 line 552193.952,4661140.999 line 552319.109,4661146.805 line 552319.109,4661146.805 line 552319.109,4661146.805 line 552361.171,4661074.458 line 553002.915,4661032.377 line 553006.666,4661032.714 line 553079.581,4661026.705 line 553082.421,4661027.569 line 553115.594,4661024.621 line 553151.366,4661022.381 line 553936.041,4661309.332 line 553979.616,4661327.816 line 554182.499,4661471.126 line 560609.575,4662815.169 line 560669.461,4662820.558 line 561243.185,4662796.177 line 561245.675,4662795.471 line 561495.981,4662775.531 line 561752.641,4662753.481 line 562091.455,4662726.121 line 562565.838,4662687.238 line 562903.633,4662648.881 line 563011.118,4662638.051 line 563590.818,4662593.777 line 563659.711,4662592.151 line 563796.467,4662578.998 line 563965.225,4662443.815 line 564153.206,4662283.253 line 564223.827,4662222.916 line 564703.949,4661817.571 line 564839.767,4661703.427 line 564867.347,4661679.377-text j ml 501153.618,4632174.901 5 0 A5 -text j ml 501156.503,4632179.252 5 0 A6 -text j ml 501850.281,4632255.353 5 0 A9 -text j ml 501863.619,4632252.173 5 0 A10 -text j ml 501867.724,4632252.576 5 0 A14 -text j ml 502613.558,4632082.716 5 0 A39 -text j ml 502671.079,4632068.918 5 0 A40 -text j ml 502934.801,4632008.002 5 0 A45 -text j ml 502976.086,4632002.232 5 0 A46 -text j ml 503351.733,4631945.757 5 0 A47 -text j ml 503421.668,4632042.612 5 0 A48 -text j ml 503563.675,4632252.002 5 0 A49 -text j ml 503587.344,4632287.267 5 0 A50 -text j ml 503679.144,4632423.879 5 0 A51 -text j ml 503737.963,4632508.371 5 0 A54 -text j ml 504277.721,4633297.878 5 0 A55 -text j ml 504352.048,4633398.339 5 0 A57 -text j ml 504746.284,4634042.084 5 0 A58 -text j ml 505118.918,4634222.422 5 0 A61 -text j ml 505540.322,4634466.529 5 0 A62 -text j ml 505761.717,4634714.829 5 0 A63 -text j ml 505784.832,4634738.729 5 0 A64 -text j ml 505856.886,4634821.732 5 0 A66 -text j ml 506079.497,4634991.238 5 0 A67 -text j ml 506272.002,4635179.998 5 0 A72 -text j ml 506314.487,4635186.976 5 0 A73 -text j ml 506417.685,4637316.904 5 0 A77 -text j ml 506489.434,4635402.025 5 0 A78 -text j ml 506547.339,4635475.807 5 0 A81 -text j ml 506779.863,4635755.523 5 0 A82 -text j ml 507036.274,4636017.811 5 0 A87 -text j ml 507036.274,4636017.811 5 0 A87 -text j ml 507373.648,4636266.035 5 0 A88 -text j ml 507431.571,4636327.354 5 0 A89 -text j ml 507587.561,4636585.762 5 0 A95 -text j ml 507587.561,4636585.762 5 0 A95 -text j ml 507702.592,4636750.037 5 0 A96 -text j ml 507716.956,4636772.856 5 0 A97-text j ml 508209.631,4637179.151 5 0 A108 -text j ml 508209.631,4637179.151 5 0 A108 -text j ml 508667.541,4637728.817 5 0 A109 -text j ml 509388.998,4638688.137 5 0 A111 -text j ml 509388.998,4638688.137 5 0 A111 -text j ml 509654.933,4638911.104 5 0 A112 -text j ml 510007.681,4639132.361 5 0 A125 -text j ml 510007.681,4639132.261 5 0 A125 -text j ml 511185.217,4639764.235 5 0 A126 -text j ml 511281.192,4639961.435 5 0 A127 -text j ml 511216.396,4640413.826 5 0 A128 -text j ml 511214.285,4640444.421 5 0 A129 -text j ml 511214.156,4640620.376 5 0 A130 -text j ml 511642.141,4641115.896 5 0 A147 -text j ml 511642.141,4641115.896 5 0 A147 -text j ml 511732.326,4641196.328 5 0 A148 -text j ml 511927.674,4641510.557 5 0 A163 -text j ml 512116.987,4641955.451 5 0 A165 -text j ml 512122.175,4641972.882 5 0 A166 -text j ml 513124.041,4643658.081 5 0 A169 -text j ml 513285.492,4643582.604 5 0 A174 -text j ml 513446.771,4643425.204 5 0 A176 -text j ml 513573.762,4643312.649 5 0 A181 -text j ml 513610.812,4643284.776 5 0 A182 -text j ml 513616.516,4643281.619 5 0 A183 -text j ml 513725.439,4643182.519 5 0 A184 -text j ml 513729.761,4643174.929 5 0 A185 -text j ml 513743.111,4643161.652 5 0 A186 -text j ml 513953.645,4642932.301 5 0 A187 -text j ml 513987.411,4642899.945 5 0 A190 -text j ml 514113.161,4642764.962 5 0 A191 -text j ml 514272.384,4642590.763 5 0 A199 -text j ml 514272.384,4642590.763 5 0 A199 -text j ml 514272.384,4642590.763 5 0 A199 -text j ml 514743.782,4642138.738 5 0 A200 -text j ml 514782.642,4642164.809 5 0 A201 -text j ml 515071.671,4642621.305 5 0 A202 -text j ml 515081.923,4642636.984 5 0 A203 -text j ml 515319.285,4643007.004 5 0 A212-text j ml 515429.818,4643173.553 5 0 A217 -text j ml 515463.182,4643233.397 5 0 A218 -text j ml 515621.261,4643409.274 5 0 A219 -text j ml 515834.553,4643779.727 5 0 A228 -text j ml 515914.953,4644021.036 5 0 A236 -text j ml 515999.405,4644250.772 5 0 A237 -text j ml 516004.064,4644284.743 5 0 A239 -text j ml 516015.532,4644356.885 5 0 A240 -text j ml 516070.827,4644617.597 5 0 A242 -text j ml 516075.735,4644662.081 5 0 A243 -text j ml 516104.439,4644825.099 5 0 A244 -text j ml 516200.879,4645247.116 5 0 A254 -text j ml 516297.279,4645479.888 5 0 A255 -text j ml 516441.837,4645894.009 5 0 A266 -text j ml 516430.363,4645904.569 5 0 A267 -text j ml 516265.991,4646108.579 5 0 A268 -text j ml 516671.166,4646535.082 5 0 A271 -text j ml 516751.411,4646725.723 5 0 A277 -text j ml 516950.588,4647073.644 5 0 A279 -text j ml 516959.009,4647080.434 5 0 A280 -text j ml 517076.291,4647196.201 5 0 A282 -text j ml 517079.892,4647202.103 5 0 A283 -text j ml 517316.689,4647405.651 5 0 A284 -text j ml 517595.146,4647492.872 5 0 A292 -text j ml 517903.082,4647559.724 5 0 A294 -text j ml 518027.962,4647904.686 5 0 A295 -text j ml 521649.439,4648104.191 5 0 A306 -text j ml 524392.648,4651783.281 5 0 A314 -text j ml 525152.011,4654587.771 5 0 A315 -text j ml 525152.011,4654587.771 5 0 A315 -text j ml 525174.227,4654602.692 5 0 A316 -text j ml 525174.227,4654602.692 5 0 A316 -text j ml 528966.142,4656048.996 5 0 A318 -text j ml 529161.893,4656068.159 5 0 A319 -text j ml 529357.106,4656089.011 5 0 A323 -text j ml 530323.754,4656280.008 5 0 A325 -text j ml 530452.775,4656316.631 5 0 A327 -text j ml 531195.866,4656467.035 5 0 A347-text j ml 531195.866,4656467.035 5 0 A347 -text j ml 531195.866,4656467.035 5 0 A347 -text j ml 544637.126,4665886.529 5 0 A348 -text j ml 543462.566,4663675.354 5 0 A355 -text j ml 543448.671,4663656.069 5 0 A356 -text j ml 543432.299,4663631.978 5 0 A358 -text j ml 543428.681,4663610.825 5 0 A359 -text j ml 540426.373,4661663.457 5 0 A369 -text j ml 540416.014,4661658.451 5 0 A370 -text j ml 539428.848,4660955.621 5 0 A371 -text j ml 538482.616,4660167.829 5 0 A375 -text j ml 538477.442,4660164.743 5 0 A376 -text j ml 538414.601,4660116.949 5 0 A377 -text j ml 538410.322,4660113.652 5 0 A378 -text j ml 538398.013,4660103.247 5 0 A379 -text j ml 538391.926,4660101.819 5 0 A380 -text j ml 538314.296,4660038.714 5 0 A381 -text j ml 538263.223,4660003.899 5 0 A385 -text j ml 538046.705,4659900.241 5 0 A387 -text j ml 537969.793,4659864.838 5 0 A391 -text j ml 537616.306,4659716.424 5 0 A393 -text j ml 537612.819,4659714.414 5 0 A394 -text j ml 537339.103,4659601.392 5 0 A396 -text j ml 537332.013,4659598.791 5 0 A397 -text j ml 536942.391,4659438.479 5 0 A399 -text j ml 536938.533,4659435.805 5 0 A400 -text j ml 535302.547,4658514.409 5 0 A407 -text j ml 535302.093,4658510.169 5 0 A408 -text j ml 533211.102,4657201.843 5 0 A415 -text j ml 544713.824,4666035.854 5 0 A416 -text j ml 544794.398,4666050.744 5 0 A418 -text j ml 545904.923,4666733.808 5 0 A419 -text j ml 546497.511,4667283.793 5 0 A421 -text j ml 546498.493,4667286.321 5 0 A422 -text j ml 547010.051,4667979.555 5 0 A423 -text j ml 548944.104,4667988.265 5 0 A424 -text j ml 548904.265,4667977.111 5 0 A425 -text j ml 548944.104,4667988.265 5 0 A425 -text j ml 548944.104,4667988.265 5 0 A425-text j ml 549885.945,4669457.701 5 0 A426 -text j ml 550036.716,4669691.656 5 0 A432 -text j ml 550061.556,4669732.282 5 0 A433 -text j ml 550067.987,4669740.811 5 0 A434 -text j ml 550579.477,4670594.118 5 0 A435 -text j ml 550581.549,4670600.267 5 0 A436 -text j ml 550586.915,4670621.302 5 0 A437 -text j ml 550314.177,4671016.421 5 0 A448 -text j ml 550431.572,4671589.652 5 0 A449 -text j ml 550541.849,4671784.397 5 0 A456 -text j ml 550593.114,4671800.754 5 0 A457 -text j ml 551176.748,4671698.999 5 0 A471 -text j ml 551241.756,4671685.828 5 0 A473 -text j ml 551247.364,4671694.481 5 0 A474 -text j ml 551253.948,4671702.186 5 0 A475 -text j ml 551376.091,4671923.405 5 0 A477 -text j ml 551380.331,4671930.395 5 0 A478 -text j ml 551990.305,4672939.184 5 0 A480 -text j ml 551992.521,4672944.381 5 0 A481 -text j ml 551997.617,4672951.459 5 0 A482 -text j ml 552002.748,4672958.286 5 0 A483 -text j ml 552104.123,4673127.441 5 0 A484 -text j ml 552348.336,4673539.051 5 0 A485 -text j ml 552348.336,4673539.051 5 0 A485 -text j ml 552356.806,4673550.045 5 0 A486 -text j ml 552376.628,4673582.146 5 0 A487 -text j ml 552414.748,4673640.869 5 0 A489 -text j ml 552475.218,4673736.585 5 0 A490 -text j ml 552654.819,4674031.471 5 0 A499 -text j ml 552693.157,4674096.212 5 0 A500 -text j ml 552699.599,4674104.239 5 0 A501 -text j ml 553049.686,4674679.371 5 0 A502 -text j ml 553053.137,4674684.312 5 0 A503 -text j ml 553055.184,4674688.574 5 0 A504 -text j ml 553062.406,4674698.801 5 0 A505 -text j ml 545619.684,4665901.874 5 0 A508 -text j ml 545623.321,4665899.747 5 0 A509 -text j ml 547677.179,4665246.222 5 0 A510 -text j ml 548441.451,4664663.981 5 0 A513-text j ml 548445.179,4664659.209 5 0 A514 -text j ml 549357.567,4663933.177 5 0 A518 -text j ml 550246.094,4663357.081 5 0 A520 -text j ml 552193.952,4661140.999 5 0 A524 -text j ml 552319.109,4661146.805 5 0 A525 -text j ml 552319.109,4661146.805 5 0 A525 -text j ml 552319.109,4661146.805 5 0 A525 -text j ml 552361.171,4661074.458 5 0 A526 -text j ml 553002.915,4661032.377 5 0 A527 -text j ml 553006.666,4661032.714 5 0 A528 -text j ml 553079.581,4661026.705 5 0 A529 -text j ml 553082.421,4661027.569 5 0 A530 -text j ml 553115.594,4661024.621 5 0 A531 -text j ml 553151.366,4661022.381 5 0 A532 -text j ml 553936.041,4661309.332 5 0 A533 -text j ml 553979.616,4661327.816 5 0 A536 -text j ml 554182.499,4661471.126 5 0 A537 -text j ml 560609.575,4662815.169 5 0 A539 -text j ml 560669.461,4662820.558 5 0 A541 -text j ml 561243.185,4662796.177 5 0 A542 -text j ml 561245.675,4662795.471 5 0 A543 -text j ml 561495.981,4662775.531 5 0 A544 -text j ml 561752.641,4662753.481 5 0 A553 -text j ml 562091.455,4662726.121 5 0 A554 -text j ml 562565.838,4662687.238 5 0 A566 -text j ml 562903.633,4662648.881 5 0 A567 -text j ml 563011.118,4662638.051 5 0 A571 -text j ml 563590.818,4662593.777 5 0 A572 -text j ml 563659.711,4662592.151 5 0 A574 -text j ml 563796.467,4662578.998 5 0 A576 -text j ml 563965.225,4662443.815 5 0 A581 -text j ml 564153.206,4662283.253 5 0 A582 -text j ml 564223.827,4662222.916 5 0 A586 -text j ml 564703.949,4661817.571 5 0 A587 -text j ml 564839.767,4661703.427 5 0 A591 -text j ml 564867.347,4661679.377 5 0 A592。
如何将 Excel坐标(X ,Y , Z)导入CAD中,显示高程
EXECL坐标（X ,Y , Z）导入CAD
本文教你将测量测到的坐标（X,Y,Z），导入到CAD呈现出我们需要看到的数据（高程、编号）。
效果如下图所示，不是本类的童鞋可以撤了。
首先第一步：在E2中输入{ =“point ”&B2&”,”&C2 }，B2（CAD图的）X，C2为Y。
这里需要注意，有点测量坐标的X,Y表示和CAD的X,Y表示相反，请童鞋注意查验。
如下图中就是这种情况：
图上其实就是CAD中的画点指令。
然后进入第二步：在F2中输入{ =-text j bc “&B2+0.5&”,”&C2+0.5&” “&2& ”0” “&D2 }，B2，C2为X,Y坐标，0.5为标志偏移量，2为文字高度，0为文字旋转角，D2为高程（你想表示什么都做这里展现）。
怕你看不清EXCEL完整命令=-TEXT空格J空格BC空格“&B2+0.5&”,”&C2+0.5&”空格“&2&空格”空格0空格”空格“&D2
下拉填充EXCEL单元格
然后进入第三步：导入CAD了；在EXCEL中选中E列，F列然后”CTRL+C”复制，
CAD输入框中“CTRL+V”粘贴，等待导入结束。
CTRL+V
至上图我们导入CAD就结束了，下面赠送亮睛工程，输入DDPTYPE，选择你想要的点式样，“大小”要选“绝对”，绝对才能美美哒。
如果看不到图形，可输入“zoom”，然后选择“A”,即可看到图形。
坐标点及点名称批量导入CAD
坐标点及点名称批量导入CAD
1、先将EXCEL中坐标，按照如图所示的填好：
D2表格填写公式为：="point "&B2&","&C2E2表格填写公式为：=="text "&B2+10&","&C2+10& " 10 0 "&A2其中，point后面需要加空格，text后面需要加空格，10前后都需要加空格，0后面需要加空格。
空格的意思执行该命令，不能少否则会出错，10为文字高度可以调整，0为文字旋转角度；（B2+10，C2+10）相对于原来坐标点的位置。
2、将D列文字复制到文本，如图所示：
精品
3、修改文本文件的后缀即文件格式，改为scr格式。
4、在CAD工具里面运行脚本文件，即SCR文件。
5、同样的方法可以对E列进行操作，生成点的名称。
如有侵权请联系告知删除，感谢你们的配合！
精品。
坐标点怎么导入进CAD中
坐标点怎么导入进CAD中在CAD里面有时候需要用到外部坐标点数据，那么大家知道坐标点怎么导入进CAD中吗?下面是店铺整理的坐标点怎么导入进CAD中的方法，希望能给大家解答。
坐标点导入进CAD中的方法1.利用EXCEL输入点坐标首先，在Excel中输入坐标值(注意要输入绝对坐标)。
我们将X坐标值放入A列，Y坐标值放入到B列，再将A列和B列合并成C列，由于CAD中二维坐标点之间是用逗号隔开的，所以我们在C2单元格中输入：=A2&”，“&B2，C2中就出现了一对坐标值。
我们用鼠标拖动的方法将C2的公式进行复制，就可以得到一组坐标值。
如下图所示：其次，选出所需画线的点的坐标值，如上例中C列数据，按Ctrl+C将其复制到剪贴板上。
打开CAD，在命令行输入画线的命令，例如L(直线)、PL(多段线)、SPL(样条线)，回车提示定位的第一点时，将复制的坐标用Ctrl+V粘贴到命令行，即可快速完成这些点的绘制。
然后根据命令行提示选择封闭或单击鼠标右键完成曲线的绘制。
2.保存CAD脚本文件，EXCEL将点坐标保存成txt格式打开Excel文件-文件-另存为-保存类型-选择“文本文件(制表符分隔)”-保存-即TXT文本格式。
将文件后缀名改为“*.lsp”3.用记事本编辑一个小的lisp程序打开记事本，将EXCL表格的内容选中拷贝并粘贴到记事本中，拷贝完成后需要用替换的方法再次进行编辑，编辑好的lisp语言如下图：特别注意，lisp语言中的全部文字和符号均要用英文半角输入，command与“point”之间只能有一个空格，“point”与“a，b”之间也只能有一个空格，其它地方不能有空格。
将记事本文件保存，关闭文件并将其后缀名改为.lsp。
3.改变CAD 中点样式在“格式”里边选“点样式”，改变点形状这种方式等分完后由于点对象位于线上，看不见，要想看到这些点，需要在菜单中选择：点样式，设置一个可以看得到的样式，如下图所示：注意：点大小有两种设置形式，一种是相对于屏幕大小的百分比，一种是绝对尺寸，使用哪种形式、多大，取决于你是否希望打印这些点，点显示后效果如下图所示：4.CAD加载脚本绘图在“工具”里边选“加载应用程序”，运行脚本“*.lsp”将坐标批量输入到CAD中打开CAD，在“工具”菜单中找到“加载引用程序”，加载这个文件，奇迹发生了，所有点自动画好了。
cad中如何导入坐标
cad中如何导入坐标
我们有时需要导入坐标来完成图纸，那么小编在这里教大家一个方法吧。
cad中如何导入坐标的方法：
1、cad坐标输入方法很简单，先用直线工具教cad绝对坐标怎么画。
首先选择cad直线工具，然后在命令行中输入“20，20”(这是cad绝对坐标输入格式)，然后回车。
2、此时会将cad直线的起点定位在相距坐标远点x轴和y轴为20距离的点上。
cad怎么输入坐标：带角度的相对坐标
1、在cad命令行中输入“@100<0”(这是cad带角度的相对坐标输入格式，意思是长度为100，角度为0度)，然后按回车键确定。
2、此时就画出来一条长度为100且角度为0度的直线。
3、cad怎么输入坐标：用距x、y轴距离确定的相对坐标
4、在cad命令行中输入“@200，100”(这表示端点距离当前起点的x轴为200，距离y轴为100)，然后按回车键确定。
EXCEL坐标(X,Y,Z)导入CAD
EXECL坐标（X ,Y , Z）导入CAD
本文教你将测量测到的坐标（X,Y,Z），导入到CAD呈现出我们需要看到的数据（高程、编号）。
效果如下图所示，不是本类的童鞋可以撤了。
首先第一步：在E2中输入{ =“point ”&B2&”,”&C2 }，B2（CAD图的）X，C2为Y。
这里需要注意，有点测量坐标的X,Y表示和CAD的X,Y表示相反，请童鞋注意查验。
如下图中就是这种情况：
图上其实就是CAD中的画点指令。
然后进入第二步：在F2中输入{ =-text j bc “&B2+0.5&”,”&C2+0.5&” “&2& ”0” “&D2 }，B2，C2为X,Y坐标，0.5为标志偏移量，2为文字高度，0为文字旋转角，D2为高程（你想表示什么都做这里展现）。
怕你看不清EXCEL完整命令=-TEXT空格J空格BC空格“&B2+0.5&”,”&C2+0.5&”空格“&2&空格”空格0空格”空格“&D2
下拉填充EXCEL单元格
然后进入第三步：导入CAD了；在EXCEL中选中E列，F列然后”CTRL+C”复制，CAD输入框中“CTRL+V”粘贴，等待导入结束。
CTRL+V
至上图我们导入CAD就结束了，下面赠送亮睛工程，输入DDPTYPE，选择你想要的点式样，“大小”要选“绝对”，绝对才能美美哒。
Excel点坐标点号数据导入cad方法（论证版）
Excel点坐标点号数据导入cad方法（论证版）
在此处Excel导入cad的方法主要是利用将你要完成的工作通过Excel转换成N 条命令，然后交给cad来执行，以达到目的。
以下是举例：根据已知的点、文字的excel表格信息导入到cad 中。
假设表中A列为序号,B.C列为坐标,根据坐标画点,并在坐标右上角写序号文字
1.在D1中输入公式:="point "&B1&","&C1
point是画点命令,b2.c2就是坐标
在E1中输入公式: ="-text j bc "&B1+2&","&C1+2&" "&5&" 0 "&A1
text是文字命令,B1+2.C2+2是确定文字坐标,5是文字高度,0是旋转0度,A1是文字内容
2.句柄填充单元格,复制D.E列,在设置单元格格式中选择数字---右侧负数选项第三项，精确四位数。
3.打开AutoCAD，在acad中点选文本窗口的命令行,按ctrl+V粘贴，按z,然后按e。
编辑即可（要特别注意的是命令输入的确认是空格还是回车要相应的命令后添加回车或者空格。
如果失败可以执行前几条命令查看错误原因对命令进行修改）。
Excel中坐标导入CAD的方法
在此处Excel导入cad的方法主要是利用将你要完成的工作通过Excel转换成N 条命令，然后交给cad来执行，以达到目的。
以下是举例：根据已知的点、文字的excel表格信息导入到cad中。
假设表中A列为序号,B.C列为坐标,根据坐标画点,并在坐标右上角写序号文字
1.在D1中输入公式:="point "&B1&","&C1
point是画点命令,b1.c1就是坐标
在E1中输入公式:="text "&B1+2&","&C1+2&" 5 0 "&A1
text是文字命令,b1+2.c1+2是确定文字坐标,5是文字高度,0是旋转0度,a1是文字内容
2.句柄填充单元格,复制D.E列
3.把D.E列的数据复制到文本文档，把文本文档的格式改为.scr
4.把Excel中的坐标的前面加上point即点的英文写法，在点的X、Y坐标之间加上逗号，再输入一个z坐标0，0与Y坐标之间也得加上逗号，做完以上工作之后，把所有的东西全复制到文本文档中，复制之后，看是否各数字之间的不能有空格，然后把这些数字另存，但文本文档的的后缀变为.scr的格式即变成cad 的脚本文件，完成之后，最后打开cad在工具里直接运行这个脚本文件就可以了。
坐标导入cad
36：，4cJ 'f925-l: H 1?lfl也很笨，不过很管用有的时候用加载脚本还会出现问题，这个一般没得问题滴，就是点多了，可能时间比较久哈把EXCEL 里面的坐标复制后在记事本里面编辑一下 31^724. K&3138723!翱3138£JL3SS2E51381 31381 31祐： 3138£ 31朋 3138( 31赠 刃瑚卫郵富31师 汀3汀王设置完后将选择数 据.复制到文木立坪卫 确疋 祀芸旧 jSA（1'.ni IHQ1 布需见〕 旨匚吃 即氏1则然后在前面加个pline ，最后加一个C,复制到CAD 的命令窗口，回车就完成了 （这个方法虽然原始CAD 简易EXCEL S 据成图步骤1.JPG （96.14 KB, 下载次数：15））操作方法步聚如下鄒翳用于Tim 由的希斯隔和S 式换熾Eiffi 十那11 17 L!楼内十CSirtAf ” J 曳类bI.L.JL肱 1(1〕I. 2'. 2? 77 233&J56416. D L3635C548. 4茨35需4乞9$詣 56&30K33^356631. 23&35^714. 02 3^5671-1. J7 3&356T56,55 版可珥=斤hF i363S&670.口36 3&6670. a3輻5酣四 36瑚倔5 3635$50&. 9 歸菲飯0£ 923635^^5. 6单兄I&格式15护s此处育冋车全选 制下载次数：7)直片也 脊输怪)曙式旦 at 北岂也 将中阳.的空格全部替换成英文 输入状态下的逗号CAD 简易 EXCEL S 据成图步骤 2.JPG (211.25 KBS1 St 715, mo 3138771_1DOfl<3138770.07811Bl8BBlO P SU«a313B76H-/Uan 313>g/fli.3UQ» 118BQ31,5000 3i3Bfi31.seoa 扪地■mnn 爼伽S188032 .«g*0 siaiflaa^oee 31M7K «tBH刑防吐酗心』U ・ 廿恵g 与矗自” 93A?5663fl.629e 363%M81 .2^0 363«&71«1.0170 □A^6714.fl74D 36356 rb&_5UHB ae 林尙心『•・3^66 ? 9ft□435662^.fl36%6A2»»»A5C5.?»CV56356*45-6 CfcFi B•「地It ■网5 M H 1 1 J 4JIHF 样疋命5刃洛古型pline3635AU6 亠0 *313SJ25 - 9B2 0 .<®3S6^4».*!«««,3iy#f?*i.U 御 M 虚铀AWM ■扪:ypji _ iMmHH 苇虚昌訂 fl . fl , 31 □ fl!770 fl7S 0 3635*631.Z9U0%31□B&l &.3990jm6m.ui/u.3iyBHis.mo 帥胳嶺1轟■釧期Mhp 訓m. £蛹 fl S 31 OftTfi R . ?aoo□«&?&.2000^3^66^^■UCUSUBbF* ■旳.2。