JAVA操作EXCEL文件

package excel;

import jxl.Sheet;
import java.io.InputStream;
import java.util.ArrayList;
import java.io.FileInputStream;
import jxl.Workbook;
import java.util.List;

public class Test2 {
public static void main(String [] args){
List list = ReadExcel("D:/project/test/SellCompositor.xls");
for(int i=0;i<list.size();i++){
System.out.println("list["+i+"]="+list.get(i));
}
}
public Test2() {
}
/*
* 方法名：ReadExcel
* 参数：filePath为Execl文件的绝对路径
* 用途：读取Execl数据,放在数组中返回
*返回类型：Vector
*
* */
public static List ReadExcel(String filePath)
{
List al = new ArrayList();
Workbook rwb = null;
try
{
InputStream is = new FileInputStream(filePath);
rwb = Workbook.getWorkbook(is);
// 获取第一张Sheet表
// Sheet rs = rwb.getSheet(0);
for(int i=0;i<3;i++){
getExcel(al, rwb.getSheet(i));
}
rwb.close();
}
catch (Exception e)
{
e.printStackTrace();
}
return al;
}

private static void getExcel(List list, Sheet rs) {
for (int k = 0; k < rs.getRows(); k++)
{
for (int j = 0; j < rs.getColumns(); j++)
{
System.out.println("value["+j+","+k+"]="+rs.getCell(j, k).getContents());
list.add(rs.getCell(j, k).getContents());
}
}
}

}