readfenjieexcel.java

基于Java的地图数据管理软件。使用MySQL数据库管理系统。

package net.aetherial.gis.jiaotongbu.outputJTB.prepare.huafen.quyu;

import net.aetherial.gis.jiaotongbu.outputJTB.txtOutput.module.excel.ReadRecord;
import net.aetherial.gis.test.tools.lost.publicuse.Parameter;
import net.aetherial.gis.publicuse.excel.ReadSheet;
import jxl.LabelCell;
import jxl.NumberFormulaCell;
import jxl.NumberCell;

/**
 * <p>标题: 农村公路数据采集与核对工具</p>
 *
 * <p>描述: </p>
 *
 * <p>版权: Copyright (c) 2006</p>
 *
 * <p>公司: 安徽省通途信息技术公司</p>
 *
 * @author 王爱国
 * @version 1.0
 */
public class ReadFenjieExcel
    extends ReadRecord {
  public ReadFenjieExcel(String xiangzhenbiao) {
    super(null);
    ReadSheet rs = new ReadSheet();
    rs.setSheetFile(xiangzhenbiao, "乡镇交界");
//    si.setQiaoliangFangxiang(fangxiangFile);
    this.setSheet(rs.getMySheet());
    if (this.mySheet == null) {
      rs.setSheetFile(xiangzhenbiao, 0);
//    si.setQiaoliangFangxiang(fangxiangFile);
      this.setSheet(rs.getMySheet());
      if (this.mySheet == null) {
        System.out.println("没有发现  上报表格\\表-8.xls " + xiangzhenbiao);
        System.exit(0);
      }
    }
    this.setRow(5);

  }

  public void read() {

    FenjieRow fenjie =  null;

    for (int i = 0; (!this.isEmptyrow()) && i < 500; i++) {
      if (this.rowData != null) {
        fenjie = new FenjieRow();
        fenjie.setValue(this.rowData);
        Permance.xianFenjieRows.add(fenjie);
//        System.out.println("");
      }
      this.moveNext();
    }

  }

  public static void main(String args[]){
    ReadFenjieExcel read = new ReadFenjieExcel("E:\\农村公路通达情况调查\\数据\\报省数据\\通达情况专项调查\\安徽省\\蚌埠市\\五河县\\上报表格\\表-8.xls");
    read.read();
    Permance.printFenjieRows();

    FenjieRow[] temp = Permance.getFenjieRows("X036");
    for (int i = 0; i < temp.length; i++) {
      System.out.println("X036:" + temp[i]);
    }

  }

}