//定义格式

WritableCellFormat wcf = new WritableCellFormat(NumberFormats.TEXT);

CellView cv = new CellView(); //定义一个列显示样式

cv.setFormat(wcf);//把定义的单元格格式初始化进去

cv.setSize(10*600);//设置列宽度（不设置的话是0，不会显示）

sheet.setColumnView(4,cv);//设置工作表中第4列的样式

Jxl解析方式

1.主要类

WritableWorkbook //整个文档对象

WritableSheet

WritableFont

WritableCellFormat

…

Poi解析方式excel例子

String message="";

InputStream is = null;

try {

FileActionForm fileActionForm = (FileActionForm) form;

is = fileActionForm.getFile().getInputStream();

HSSFWorkbook hssfWorkbook = new HSSFWorkbook( is);

HSSFSheet hssfSheet = hssfWorkbook.getSheetAt(0);

HSSFRow hssfRow1 = hssfSheet.getRow(1);

HSSFRow hssfRow2 = hssfSheet.getRow(2);

String depa_code = getCellValue(hssfRow1, 5);

if(depa_code.equals("")){

request.setAttribute("message", "单位编码未填写!");

return mapping.findForward("importSuccess");

}else if(!this.getSessionDepa_Code(request).equals(depa_code)){

request.setAttribute("message", "单位编码不正确!");

return mapping.findForward("importSuccess");

}

Department department = this.getDepartmentByCode(depa_code);

SecondImmuReportDTO secondImmuReport = new SecondImmuReportDTO();

secondImmuReport.setSeir_depa_id(department.getDepa_id());

secondImmuReport.setSeir_nationcode(depa_code);

if("".equals(getCellValue(hssfRow1, 1))||"".equals(getCellValue(hssfRow2, 1))){

request.setAttribute("message", "年份或是月份未填写!");

return mapping.findForward("importSuccess");

}

secondImmuReport.setSeir_statdate(getCellValue(hssfRow1, 1)+getCellValue(hssfRow2, 1));

secondImmuReport.setSeir_resi_id(1);//户籍住址

secondImmuReport.setSeir_countycheck("0");

secondImmuReport.setSeir_countyupload("0");

secondImmuReport.setSeir_citycheck("0");

secondImmuReport.setSeir_cityupload("0");

secondImmuReport.setSeir_provincecheck("0");

secondImmuReport.setSeir_provinceupload("0");

//先按照单位code 年月份 某一个疫苗code

secondImmuReport.setQueryOneSql("selectOneSecondImmuReport");

secondImmuReport.setSeir_bact_code("02");

SecondImmuReportDTO secondImmuReport1 = (SecondImmuReportDTO) this.processCommandForObject(CommandList.COMMON_COMMAND, Constant.REQUEST_ACTION_COMMONQUERYONE, secondImmuReport, secondImmuReport);

if(null!=secondImmuReport1){

if(secondImmuReport1.getSeir_countycheck().equals("1")){//已经存在且区县已经审核过，不让导入

request.setAttribute("message", "这个月份已经导入过数据，且上级已经审核,不能再导入!");

return mapping.findForward("importSuccess");

}else{

//删除此单位，这个年月份 的 secondImmuReport.setDeleteSql("secondImmuReportDeleteAllByKeys"); this.processCommandForObject(CommandList.COMMON_COMMAND, Constant.REQUEST_ACTION_COMMONDELETE, secondImmuReport, secondImmuReport);

message = "这个月份已经导入过数据,现在更新成功!";

}

}

secondImmuReport.setInsertSql("secondImmuReportInsert");

String [][]bact_code = {{"02","2501"},{"06","9202"},{"14","29"},{"13","34"},{"12","36"},{"11","28"},{"10","44"},{"1801","43"},{"1802","30"},{"1602","33"},{"1703","37"},{"1901","35"},{"1903","38"},{"2001","47"},{"2301","48"},

{"22","26"},{"24","0303"},{"21","50"}};//按照导入模板疫苗顺序

for(int i=5;i<23;i++){

//添加

HSSFRow hssfRow = hssfSheet.getRow(i);

for(int j= 0;j<2;j++){

secondImmuReport.setSeir_bact_code(bact_code[i-5][j]);

secondImmuReport.setSeir_inoculated(Integer.parseInt(getCellValue(hssfRow,(2*j)+1)));

this.processCommandForObject(CommandList.COMMON_COMMAND, Constant.REQUEST_ACTION_COMMONINSERT, secondImmuReport, secondImmuReport);

}

}

if("".equals(message)){message = "添加成功!";}

} catch (Exception e) {

message = "添加失败,可能是填写格式不对!";

e.printStackTrace();

} finally{

is.close();

}

request.setAttribute("message", message);

}

return mapping.findForward("importSuccess");

Jxl设置列的格式为文本