jxl.jar为开源代码,任何运行java虚拟机的操作系统都能使用这个jar包操作excel表格。优点是:不依赖其他任何第三方的库。下载地址:http://mirrors.ibiblio.org/pub/mirrors/maven2/net/sourceforge/jexcelapi/jxl 下载最新版本
import jxl.Cell;
import jxl.CellType;
import jxl.Sheet;
import jxl.Workbook;
import jxl.write.Label;
jxl.Workbook readwb = null;
try{
String files = "e:\\Platform_nullData_file\\temp\\" + fileId+".xls";
InputStream instream = new FileInputStream(files);
readwb = Workbook.getWorkbook(instream);
//获取Sheet表个数
int num = readwb.getNumberOfSheets();
for(int i=0;i<num;i++){
System.out.println("第"+(i+1)+"张表");
Sheet readsheet = readwb.getSheet(i);
String sheetName = readsheet.getName();//获取Sheet名称
//获取Sheet表中所包含的总列数
int rsColumns = readsheet.getColumns();
//获取Sheet表中所包含的总行数
int rsRows = readsheet.getRows();
for(int m= 0; m < rsRows; m++){
for (int n = 0; n < rsColumns; n++) {
Cell cell = readsheet.getCell(j, i);
System.out.print(cell.getContents());
}
System.out.println("");
}
}
}catch (Exception e) {
e.printStackTrace();
}finally {
readwb.close();
}
//测试了下。貌似只能导入2003excel版本