excelutil java_Java导入导出Excel工具类ExcelUtil

public MapexportMessageExcelFile(String title, String[] headers,List dossierList, OutputStream out, String pattern)

{boolean flag = true;

Map map = new HashMap();

StringBuffer messageFile= newStringBuffer();//声明一个工作薄

HSSFWorkbook workbook = newHSSFWorkbook();//生成一个表格

HSSFSheet sheet =workbook.createSheet(title);//设置表格默认列宽度为15个字节

sheet.setDefaultColumnWidth((short) 15);//生成一个样式

HSSFCellStyle style =workbook.createCellStyle();

style.setBorderBottom(HSSFCellStyle.BORDER_THIN);

style.setBorderLeft(HSSFCellStyle.BORDER_THIN);

style.setBorderRight(HSSFCellStyle.BORDER_THIN);

style.setBorderTop(HSSFCellStyle.BORDER_THIN);

style.setAlignment(HSSFCellStyle.ALIGN_CENTER);//产生表格标题行

HSSFRow row = sheet.createRow(0);for (short i = 0; i < headers.length; i++) {

HSSFCell cell=row.createCe