readstandard.java

来自「基于Java的地图数据管理软件。使用MySQL数据库管理系统。」· Java 代码 · 共 45 行

package net.aetherial.gis.excel;
import java.io.*;
import jxl.*;

public class ReadStandard {
  private Workbook workbook = null;
  private Sheet sheet =null;
  public Cell cell = null;

  public ReadStandard(String filePath) {//filePath 指读取文件的地址//default:"D:\\GIS\\Excel\\standard\\standard1.xls"
    try{
      workbook = Workbook.getWorkbook(new File(filePath)); ;
    }catch(Exception e){
      e.printStackTrace();
    }
  }

  public void setSheet(int sheetID){
    try{
      this.sheet = workbook.getSheet(sheetID);
    }catch(Exception e){
      e.printStackTrace();
    }
  }

  public void setCell(int col,int row){
    try{
      this.cell = sheet.getCell(col,row);
    }catch(Exception e){
      e.printStackTrace();
    }
  }
  public Sheet getSheetStandard(int position){
    this.setSheet(position);
    return this.sheet;
  }

  public static void main(String args[]){
    ReadStandard rs = new ReadStandard("D:\\GIS\\Excel\\standard\\standard1.xls");
    rs.setSheet(0);
    rs.setCell(3,10);
    System.out.println(rs.cell.getType().toString()+"   " + rs.cell.getContents());
  }
}