使用jxl读excel文件例子

package com.artron.test;

import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;

import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;

public class ExcelRead {

/**
* @param args
*/
public static void main(String[] args) {

InputStream in = null;

Workbook workbook=null;
try {
// workbook = Workbook.getWorkbook(new File("c://test.xls"));

// workbook = Workbook.getWorkbook(in);

//in = new FileInputStream("c://test.xls");
in = new FileInputStream("c://222.xls");

workbook = Workbook.getWorkbook(in);

Sheet sheet=workbook.getSheet(0);

for (int i=0;i<sheet.getRows();i++)
{
Cell[] row = sheet.getRow(i);

for (int j=0;j<row.length;j++)
{
System.out.println(row[j].getContents()+"--type="+row[j].getType());


}


}

//Cell c2=sheet.getCell(1, 1);
//String cc=c2.getContents();
//System.out.println(cc);


} catch (BiffException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
try {
in.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

workbook.close();
}

}

}