easypoi导出excel不设置样式_POI Excel导出样式设置

HSSFSheet sheet = workbook.createSheet("sheetName"); //创建sheet

sheet.setVerticallyCenter(true);

//下面样式可作为导出左右分栏的表格模板

sheet.setColumnWidth((short) 0, (short) 2600);// 设置列宽

sheet.setColumnWidth((short) 1, (short) 2400);

sheet.setColumnWidth((short) 2, (short) 2300);

sheet.setColumnWidth((short) 3, (short) 1600);

sheet.setColumnWidth((short) 4, (short) 1800);

sheet.setColumnWidth((short) 5, (short) 1000);// 空列设置小一些

sheet.setColumnWidth((short) 6, (short) 2600);// 设置列宽

sheet.setColumnWidth((short) 7, (short) 2400);

sheet.setColumnWidth((short) 8, (short) 2300);

sheet.setColumnWidth((short) 9, (short) 1600);

sheet.setColumnWidth((short) 10, (short) 1800);

HSSFCellStyle cellstyle = (HSSFCellStyle) workbook.createCellStyle();// 设置表头样式

cellstyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);// 设置居中

HSSFCell