POI的操作excel示例工具类.doc

由于近期项目要用到excel来转存页面中的表单数据,对poi操作excel进行了一番了解,写了以下,但总觉的不是很好 特此:发布在此供大家评论,广义集思,还望多多指教 ?? 1. workBook处理类 Java代码 /** ? ?*?Excel?WorkBook工具类 ? ?*?@author?dsy ? ?*?@version?1.0 ? ?*/?? public?class?ExcelWorkBook?{ ?? ???? ?? ????public?HSSFWorkbook?workbook?=?null; ?? ????public?static?HSSFWorkbook?workbookTemp?=?null; ?? ????//设置当前workbookName ?? ????private?String?workbookName?=?null; ?? ????private?HSSFSheet?sheet?=?null; ?? ????private?FileOutputStream?fileOut; ?? ???? ?? ????public?ExcelWorkBook()?{ ?? ????????if(workbook?!=?null)?{ ?? ????????????workbook?=?null; ?? ????????} ?? ????????workbook?=?workbookTemp; ?? ????} ?? ???? ?? ????public?ExcelWorkBook(String?workbookName)?{ ?? ????????workbook?=?workbookTemp; ?? ????????setWorkbookName(workbookName); ?? ????} ?? ????public?String?getWorkbookName()?{ ?? ????????return?workbookName; ?? ????} ?? ?? ????public?void?setWorkbookName(String?workbookName)?{ ?? ????????workbookName?=?workbookName; ?? ????} ?? ?? ????public?HSSFSheet?getSheet()?{ ?? ????????sheet?=?workbook.createSheet(getWorkbookName()); ?? ????????return?sheet; ?? ????} ?? ???? ?? ????/** ? ?????*?用于stylUtils的所需要的workbook必须项所做的处理 ? ?????*?@return ? ?????*/?? ????public?static?HSSFWorkbook?getWorkbook()?{ ?? ????????return?workbookTemp; ?? ????} ?? ?? ????public?static?void?setWorkbook(HSSFWorkbook?workbook)?{ ?? ????????workbookTemp?=?workbook; ?? ????} ?? ???? ?? ????/** ? ?????*?输入当前WorkBook为下载临时文件记录 ? ?????*?@param?excelName ? ?????*/?? ????public?void?writerFileStream(String?excelName)?{ ?? ????????try?{ ?? ????????????fileOut?=?new?FileOutputStream(excelName); ?? ????????????workbook.write(fileOut); ?? ????????}?catch?(FileNotFoundException?e)?{ ?? ????????????//?TODO?Auto-generated?catch?block ?? ????????????e.printStackTrace(); ?? ????????}?catch?(IOException?e)?{ ?? ????????????//?TODO?Auto-generated?catch?block ?? ????????????e.printStackTrace(); ?? ????????}?finally?{ ?? ????????????try?{ ?? ????????????????fileOut.flush(); ?? ???????????????