<em>jxl</em>.jar 支持什么格式，支不支持<em>Excel</

高版本的jxl好像是可以的 老版本的jar包只支持2003
解析Excel还可以用POI ，这个支持新老版本的Excel
2007版本的需要使用XSSFWorkbook来处理,如果不复确定读取的excel版本的话可以写的if判断下如果后缀制为".xls"创建HSSFWorkbook 否则创建 XSSFWorkbook来对知文件进行操作即可.
Workbook excelWB = null;
Sheet oneSheet = null;
Row oneRow = null;
Cell oneCell = null;
.....
if("xls".equals(excFilSuff)){
excelWB = new HSSFWorkbook(excelFile);
}else{
excelWB = new XSSFWorkbook(excelFile);
}
//获取道第0个sheet对象
oneSheet = excelWB.getSheetAt(0);
//获取每行对象
oneRow = oneSheet.getRow(rowNum);
// 获取第几列对象
oneCell = oneRow.getCell(cellNum);

try{

SysCodeTemplateForm scpForm = (SysCodeTemplateForm) form;
FormFile formfile = scpForm.getUploadfile();
SysCodeTemplate scp = new SysCodeTemplate();
String reportfn = formfile.getFileName();
String savePath = "D:\\";
byte[] b = formfile.getFileData();
File file = new File(savePath);
if (!e799bee5baa6e4b893e5b19e366file.exists()) {
file.mkdirs();
}
File uploadFile = new File(file, reportfn);

FileOutputStream fops = new FileOutputStream(uploadFile);
fops.write(b);
fops.close();
XSSFWorkbook wookbook = new XSSFWorkbook(new FileInputStream(uploadFile));
XSSFSheet sheet = wookbook.getSheet("Sheet1");
int rows = sheet.getPhysicalNumberOfRows();
ArrayList<SysCodeTemplate> list1 = new ArrayList<SysCodeTemplate>();
ArrayList<SysCode> list2 = new ArrayList<SysCode>();
for (int i = 1; i < rows; i++) {
XSSFRow row = sheet.getRow(i);
if (row != null) {
int cells = row.getPhysicalNumberOfCells();
String value = "";
for (int j = 0; j < cells; j++) {
XSSFCell cell = row.getCell(j);
if (cell != null) {
switch (cell.getCellType()) {
case XSSFCell.CELL_TYPE_NUMERIC:
value += (long)cell.getNumericCellValue() + ",";
break;
case XSSFCell.CELL_TYPE_STRING:
value += cell.getStringCellValue() + ",";
break;
}
}
}
String valu = value.substring(0, value.length()-1);
String[] val = valu.split(",");
scp.setCodeCode(val[0]);
scp.setCodeName(val[1]);
scp.setCodeType(new Long(val[2]));
list1.add(scp);

}
}