导入excel的具体实现2003版excel

// 导入数据的不同业务标志
int ftype = getFileType();
// 保存找不到的项目名称
String pproject_N = "";
BufferedInputStream in = null;
HSSFWorkbook workbook = null;
Map map = new HashMap();
try {
in = new BufferedInputStream(new FileInputStream(file));
workbook = new HSSFWorkbook (in);
} catch (Exception e) {
e.printStackTrace();
}
HSSFSheet sheet = workbook.getSheetAt(0);
System.out.println("Excel中的总记录数rowIndex=="+ sheet.getLastRowNum());
User u = AuthContext.getUser();
ArrayList<String> valuelist = new ArrayList<String>();
ArrayList<String> commentlist = new ArrayList<String>();
int rowIndex = 1;
for (rowIndex = 1; rowIndex <= sheet.getLastRowNum(); rowIndex++) {
HSSFRow row = sheet.getRow(rowIndex);
if (row == null) {
continue;
}
HSSFCell cell = null;
HSSFCell headcell = null;
int columnIndex = 0;
for (columnIndex = 0; columnIndex <= row.getLastCellNum()-1; columnIndex++) {
String value = "";

String headvalue = "";
String headcomment = "";
cell = row.getCell(columnIndex);
value = processOldCell(cell);

map.put("str"+columnIndex, value);


if (columnIndex == 0 && value.trim().equals("")) {
break;
}
}

if(ftype == 1 || ftype == 2){

this.en = new Onlinequestion();
String name = (String) map.get("str1");
String sqlDetail = "select code_id from comm_base_code_detail where type_no='CD500002' and code_name=? ";

Map detail = query.querySingle(sqlDetail, Arrays.asList(name), true);


if(null != detail && detail.size() != 0){
name = detail.get("codeId").toString();
}else{
addActionMessage("无此题目类别!");
return;
}

if(ftype == 2 ){