将txt转到 excel中,并求二点之间的距离
急死了,有谁帮帮小女子?将txt文件导出到excel表格中,求二点之间的距离。下面四列第一列的001,002,003。。。表示每个点;第二列表示x的值;第三列表示y的值;第四列没有用的一些数据。将前三列导出到excel对应的三列中。并在四列中显示二点之间的距离。
001 343111.286 4066017.352 26.507;
002 493428.892 4066000.391 26.412;
003 493417.676 4066007.133 25.813;
004 493452.347 4066018.957 27.991;
005 493583.085 4066000.438 34.199;
006 493582.071 4066001.359 34.354;
007 493724.008 4066113.011 39.788;
008 493719.958 4066118.327 39.285;
009 493818.243 4066107.037 44.676;
010 493901.457 4066097.664 48.753;
011 493901.348 4066095.197 48.899;
012 493907.456 4066241.365 48.926;
013 493703.221 4066119.191 38.835;
014 493555.562 4065838.049 33.121;
015 493555.913 4065840.438 33.087;
016 493690.625 4065821.495 39.943;
017 494532.562 4065579.851 83.219;
018 494501.859 4065587.296 81.715;
019 494358.248 4065612.302 75.072;
020 494608.871 4065678.661 86.052;
021 494612.177 4065698.728 86.556;
022 494556.681 4065701.961 84.517;
023 494471.201 4065749.115 79.904;
024 494481.226 4065766.284 80.331;
025 494519.631 4066029.819 80.313;