如何将excel中的数据转换成mapgis明码格式的文件

zxf301 · 发表于 2010-11-3 13:27

1、以下是我们野外测的激电中梯剖面测量数据，已经输到excel表格中了

序号测量数据
1 3.43
2 3.02
3 2.32
4 1.9
5 2.65
6 3.23
7 2.13
8 2.29
9 3.1
10 3.34
11 2.39
12 2.49
13 3.29
14 3.54
15 3.23
16 5.3
17 3.37
18 3.42
19 3.97
20 2.79
21 2.65
22 2.4
23 2.01
24 1.97
25 1.74
26 9.31
27 4.54
28 2.3
29 1.55
30 1.13
31 2.4
32 1.87
33 2.36
34 2.13
35 2.41
36 2.13
37 2.39
38 2.71
39 3.18
40 2.33
41 2.84
这是excel中的数据

2、以下是把excel中的数据转换成mapgis明码格式的*.txt文件，请教各位高手他们之间是怎么转换的。

WMAP9022
26
-3 , 3.5 , 1 , 0 ," 1 ", 3 , 3 , 0 , 0 , 1 , 0 , 0 , 0 , 1 , 0 , 0
17 , 3.5 , 2 , 0 ," 6 ", 3 , 3 , 0 , 0 , 1 , 0 , 0 , 0 , 1 , 0 , 0
37 , 3.5 , 3 , 0 ," 11 ", 3 , 3 , 0 , 0 , 1 , 0 , 0 , 0 , 1 , 0 , 0
57 , 3.5 , 4 , 0 ," 16 ", 3 , 3 , 0 , 0 , 1 , 0 , 0 , 0 , 1 , 0 , 0
77 , 3.5 , 5 , 0 ," 21 ", 3 , 3 , 0 , 0 , 1 , 0 , 0 , 0 , 1 , 0 , 0
97 , 3.5 , 6 , 0 ," 26 ", 3 , 3 , 0 , 0 , 1 , 0 , 0 , 0 , 1 , 0 , 0
117 , 3.5 , 7 , 0 ," 31 ", 3 , 3 , 0 , 0 , 1 , 0 , 0 , 0 , 1 , 0 , 0
137 , 3.5 , 8 , 0 ," 36 ", 3 , 3 , 0 , 0 , 1 , 0 , 0 , 0 , 1 , 0 , 0
157 , 3.5 , 9 , 0 ," 41 ", 3 , 3 , 0 , 0 , 1 , 0 , 0 , 0 , 1 , 0 , 0
157 , 3.5 , 10 , 0 ," 41 ", 3 , 3 , 0 , 0 , 1 , 0 , 0 , 0 , 1 , 0 , 0
-12 ,-1.5 , 11 , 0 ," 0 ", 3 , 3 , 0 , 0 , 1 , 0 , 0 , 0 , 425 , 0 , 0
-12 , 8.5 , 12 , 0 ," 500 ", 3 , 3 , 0 , 0 , 1 , 0 , 0 , 0 , 425 , 0 , 0
-12 ,-11.5 , 13 , 0 ,"-500 ", 3 , 3 , 0 , 0 , 1 , 0 , 0 , 0 , 425 , 0 , 0
-12 , 18.5 , 14 , 0 ," 1000 ", 3 , 3 , 0 , 0 , 1 , 0 , 0 , 0 , 425 , 0 , 0
-12 ,-21.5 , 15 , 0 ,"-1000 ", 3 , 3 , 0 , 0 , 1 , 0 , 0 , 0 , 425 , 0 , 0
-12 , 28.5 , 16 , 0 ," 1500 ", 3 , 3 , 0 , 0 , 1 , 0 , 0 , 0 , 425 , 0 , 0
-12 ,-31.5 , 17 , 0 ,"-1500 ", 3 , 3 , 0 , 0 , 1 , 0 , 0 , 0 , 425 , 0 , 0
-12 , 38.5 , 18 , 0 ," 2000 ", 3 , 3 , 0 , 0 , 1 , 0 , 0 , 0 , 425 , 0 , 0
-12 ,-41.5 , 19 , 0 ,"-2000 ", 3 , 3 , 0 , 0 , 1 , 0 , 0 , 0 , 425 , 0 , 0
-12 , 48.5 , 20 , 0 ," 2500 ", 3 , 3 , 0 , 0 , 1 , 0 , 0 , 0 , 425 , 0 , 0
-12 ,-51.5 , 21 , 0 ,"-2500 ", 3 , 3 , 0 , 0 , 1 , 0 , 0 , 0 , 425 , 0 , 0
-2.5 ,-6.5 , 22 , 0 ," 0 ", 3 , 3 , 0 , 0 , 1 , 0 , 0 , 0 , 425 , 0 , 0
47 ,-6.5 , 23 , 0 ," 500 ", 3 , 3 , 0 , 0 , 1 , 0 , 0 , 0 , 425 , 0 , 0
97 ,-6.5 , 24 , 0 ," 1000 ", 3 , 3 , 0 , 0 , 1 , 0 , 0 , 0 , 425 , 0 , 0
147 ,-6.5 , 25 , 0 ," 1500 ", 3 , 3 , 0 , 0 , 1 , 0 , 0 , 0 , 425 , 0 , 0
161 ,-6 , 26 , 0 ," 1600 ", 3 , 3 , 0 , 0 , 1 , 0 , 0 , 0 , 425 , 0 , 0
0 , 50 , 27 , 1 ,27, 20 , 20 , 0 , 0 , 425 , 0 , 0 , 0