📄 comparewith2006plan.java
字号:
" <Cell ss:StyleID=\"s24\"/>",
" </Row>",
" <Row ss:AutoFitHeight=\"0\" ss:Height=\"24.9375\">",
" <Cell ss:MergeAcross=\"1\" ss:StyleID=\"s23\"><Data ss:Type=\"String\">项目所在地</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[1][0] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[1][1] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[1][2] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[1][3] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[1][4] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"/>",
" </Row>",
" <Row ss:AutoFitHeight=\"0\" ss:Height=\"24.9375\">",
" <Cell ss:MergeAcross=\"1\" ss:StyleID=\"s23\"><Data ss:Type=\"String\">公 路 性 质</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[2][0] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[2][1] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[2][2] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[2][3] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[2][4] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"/>",
" </Row>",
" <Row ss:AutoFitHeight=\"0\" ss:Height=\"24.9375\">",
" <Cell ss:MergeAcross=\"1\" ss:StyleID=\"s23\"><Data ss:Type=\"String\">途经行政村名称</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[3][0] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[3][1] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[3][2] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[3][3] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[3][4] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"/>",
" </Row>",
" <Row ss:AutoFitHeight=\"0\" ss:Height=\"24.9375\">",
" <Cell ss:MergeDown=\"4\" ss:StyleID=\"s23\"><Data ss:Type=\"String\">公路现状</Data></Cell>",
" <Cell ss:StyleID=\"s23\"><Data ss:Type=\"String\">线路等级</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[4][0] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[4][1] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[4][2] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[4][3] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[4][4] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"/>",
" </Row>",
" <Row ss:AutoFitHeight=\"0\" ss:Height=\"24.9375\">",
" <Cell ss:Index=\"2\" ss:StyleID=\"s23\"><Data ss:Type=\"String\">线路长度</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[5][0] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[5][1] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[5][2] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[5][3] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[5][4] + "</Data></Cell>",
" <Cell ss:StyleID=\"s26\"/>",
" </Row>",
" <Row ss:AutoFitHeight=\"0\" ss:Height=\"24.9375\">",
" <Cell ss:Index=\"2\" ss:StyleID=\"s23\"><Data ss:Type=\"String\">路基宽度</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[6][0] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[6][1] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[6][2] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[6][3] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[6][4] + "</Data></Cell>",
" <Cell ss:StyleID=\"s26\"/>",
" </Row>",
" <Row ss:AutoFitHeight=\"0\" ss:Height=\"24.9375\">",
" <Cell ss:Index=\"2\" ss:StyleID=\"s23\"><Data ss:Type=\"String\">路面宽度</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[7][0] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[7][1] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[7][2] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[7][3] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[7][4] + "</Data></Cell>",
" <Cell ss:StyleID=\"s26\"/>",
" </Row>",
" <Row ss:AutoFitHeight=\"0\" ss:Height=\"35.0625\">",
" <Cell ss:Index=\"2\" ss:StyleID=\"s23\"><Data ss:Type=\"String\">路面类型 及现状</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[8][0] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[8][1] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[8][2] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[8][3] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[8][4] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"/>",
" </Row>",
" <Row ss:AutoFitHeight=\"0\" ss:Height=\"24.9375\">",
" <Cell ss:MergeDown=\"2\" ss:StyleID=\"s23\"><Data ss:Type=\"String\">线路控制点</Data></Cell>",
" <Cell ss:StyleID=\"s23\"><Data ss:Type=\"String\">起 点</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[9][0] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[9][1] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[9][2] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[9][3] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[9][4] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"/>",
" </Row>",
" <Row ss:AutoFitHeight=\"0\" ss:Height=\"24.9375\">",
" <Cell ss:Index=\"2\" ss:StyleID=\"s23\"><Data ss:Type=\"String\">终 点</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[10][0] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[10][1] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[10][2] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[10][3] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[10][4] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"/>",
" </Row>",
" <Row ss:AutoFitHeight=\"0\" ss:Height=\"35.0625\">",
" <Cell ss:Index=\"2\" ss:StyleID=\"s23\"><Data ss:Type=\"String\">主 要 控制点</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[11][0] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[11][1] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[11][2] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[11][3] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"><Data ss:Type=\"String\">" +
tracksInfo[11][4] + "</Data></Cell>",
" <Cell ss:StyleID=\"s24\"/>",
" </Row>",
" <Row ss:AutoFitHeight=\"0\" ss:Height=\"30\">",
" <Cell ss:MergeAcross=\"1\" ss:StyleID=\"s23\"><Data ss:Type=\"String\">核查结果分析</Data></Cell>",
" <Cell ss:MergeAcross=\"5\" ss:StyleID=\"s23\"/>",
" </Row>",
" <Row ss:AutoFitHeight=\"0\">",
" <Cell ss:Index=\"2\" ss:StyleID=\"s25\"><Data ss:Type=\"String\">编制：</Data></Cell>",
" <Cell ss:Index=\"4\" ss:StyleID=\"s25\"><Data ss:Type=\"String\">复核：</Data></Cell>",
" <Cell ss:Index=\"6\" ss:StyleID=\"s25\"><Data ss:Type=\"String\">日期：</Data></Cell>",
" <Cell ss:StyleID=\"s25\"/>",
" </Row>",
"<Row ss:AutoFitHeight=\"0\">",
"<Cell ss:MergeAcross=\"7\" ss:StyleID=\"s22\"/>",
"</Row>"
}
;
String outPutYLH = "成果比较.xml"; //gpsFileName.replaceAll(".gps", "_比较.xml");
FileOutputStream fos = new FileOutputStream(new File(outPutYLH), true);
for (int i = 0; i < content.length; i++) {
fos.write(content[i].getBytes("UTF-8"));
}
fos.flush();
fos.close();
cp.getFrameOur().reset();
}else{
System.err.println(planFileName+" is empty");
}
}
public static void main(String[] args) throws Exception {
CompareWith2006Plan plan = new CompareWith2006Plan();
if (args.length < 2) {
System.out.println("too few arguments: " + args.length);
System.exit(0);
}
if (args[1].length() < 1) {
System.out.println("no GPS data for " + args[0]);
System.exit(0);
}
String planFileName = args[0];
String gpsFolderName = args[1];
File planFile = new File(planFileName);
if (planFile.isDirectory()) {
File[] planFiles = planFile.listFiles(new java.io.FilenameFilter() {
public boolean accept(File dir, String name) {
return name != null && (name.length() > 4) && ".xls".equalsIgnoreCase(name.substring(name.length() - 4));
}
});
if(planFiles.length < 1){
System.err.println(planFileName + " hasn't any plan files");
}
for (int i = 0; i < planFiles.length; i++) {
plan.run(planFiles[i], gpsFolderName);
}
}
else {
plan.run(planFile, gpsFolderName);
}
System.exit(0);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -