java解析Excel表

package com.test;

import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableImage;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

import org.junit.Test;

import java.io.File;

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

public class Test{

/**
 * 解析Excel表，
 * @author long
 *jar包下载地址：http://sourceforge.net/projects/jexcelapi/files/jexcelapi/

 */

@Test

public void method(){
try {
Workbook book = Workbook.getWorkbook(new File("F:/work/abc.xls"));
System.out.println("sheetr的name:"+book.getNumberOfSheets());//sheet个数
for(int i = 0; i<book.getNumberOfSheets(); i++){
Sheet sheet = book.getSheet(i);
System.out.println("sheet的列数:"+sheet.getColumns());
System.out.println("sheet的行数:"+sheet.getRows());

//遍历sheet的内容 
for(int c = 0; c < sheet.getColumns(); c++){
for(int j = 0; j<sheet.getRows(); j++){
System.out.println(sheet.getCell(c,j).getContents());

}
}
}



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

}

}