jxl 读取excel数据

 

import java.io.IOException;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;

public class Read {
 private java.io.File inputWorkbook;

 // private java.io.File outputWorkbook;
 public static void main(String[] args) {
  String input = "output_测试.xls";
  Read rd = new Read("output_测试.xls");
  rd.read(input);
 }

 public void read(String fileName) {
  try {
   /*
    * Workbook w1 = Workbook.getWorkbook(inputWorkbook); Sheet
    * sheet=w1.getSheet(0); int rows=sheet.getRows(); int
    * cells=sheet.getColumns();
    * System.out.println(w1.getSheetNames()[0]
    * +" rows: "+rows+" cells: "+cells);
    */
   if (isExcel(fileName)) {
    Workbook w1 = Workbook.getWorkbook(inputWorkbook);
    int sheetsLen = w1.getSheets().length;
    for (int i = 0; i < sheetsLen; sheetsLen++) {
     Sheet sheet = w1.getSheet(i);
     int rows = sheet.getRows();
     int cols = sheet.getColumns();
     for (int j = 0; j < rows; j++) {
      for (int c = 0; c < cols; c++) {
       System.out.print(sheet.getCell(c, j).getContents()
         + " ");                  //c是列数，j是行数
      }
      System.out.println();
     }
    }
   }
  } catch (BiffException e) {
   e.printStackTrace();
  } catch (IOException e) {
   e.printStackTrace();
  }
 }

 public Read(String input) {
  this.inputWorkbook = new java.io.File(input);
 }

 public java.io.File getInputWorkbook() {
  return inputWorkbook;
 }

 public void setInputWorkbook(java.io.File inputWorkbook) {
  this.inputWorkbook = inputWorkbook;
 }

 public boolean isExcel(String fileName) {
  String stuff = fileName.substring(fileName.lastIndexOf(".") + 1);
  System.out.println(fileName);
  if ("xls".equalsIgnoreCase(stuff)) {
   return true;
  }
  return false;
 }
}

 

------------------------------------------------------------和java类型对应------------

String strc00 = null;
double strc10 = 0.00;
Date strc11 = null;
Cell c00 = rs.getCell(0, 0);
Cell c10 = rs.getCell(1, 0);
Cell c11 = rs.getCell(1, 1);
if(c00.getType() == CellType.LABEL)
{
LabelCell labelc00 = (LabelCell)c00;
strc00 = labelc00.getString();
}
if(c10.getType() == CellType.NUMBER)
{
NmberCell numc10 = (NumberCell)c10;
strc10 = numc10.getValue();
}
if(c11.getType() == CellType.DATE)
{
DateCell datec11 = (DateCell)c11;
strc11 = datec11.getDate();
}