private HSSFWorkbook createExcel(List<> contactList) {
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("sheet1");
// 合并第一列
// sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 10));
// 创建标题
// HSSFRow titleRow = sheet.createRow(0);
// HSSFCell titleCell = titleRow.createCell(0);
// titleCell.setCellValue("");//表头名称
// HSSFCellStyle titleStyle = wb.createCellStyle();
// titleStyle.setAlignment(HorizontalAlignment.CENTER);
// HSSFFont titleFont = wb.createFont();
// titleFont.setBold(true);
// titleFont.setFontName("宋体");
// titleFont.setFontHeightInPoints((short) 11);
// titleStyle.setFont(titleFont);
// titleCell.setCellStyle(titleStyle);
// 创建表头
HSSFCellStyle tableStyle = wb.createCellStyle();
// tableStyle.setAlignment(HorizontalAlignment.CENTER);
HSSFFont tableFont = wb.createFont();
tableFont.setBold(false);
tableFont.setFontName("宋体");
tableFont.setFontHeightInPoints((short) 10);
tableStyle.setFont(tableFont);
tableStyle.setFont(tableFont);
HSSFRow tableRow = sheet.createRow(0);
String[] tableTitle = {"",""~~~~~~~};//表头
for (int i = 0; i < tableTitle.length; i++) {
HSSFCell ti = tableRow.createCell(i);
ti.setCellStyle(tableStyle);
ti.setCellValue(tableTitle[i]);
}
// 渲染数据
for (int i = 0; i < contactList.size(); i++) {
HSSFRow row = sheet.createRow(i + 1);
RyzzUserEx contact = contactList.get(i);
HSSFCell c0 = row.createCell(0);
c0.setCellStyle(tableStyle);
c0.setCellValue(i + 1);
HSSFCell c1 = row.createCell(1);
row.getCell(1).getSheet().setColumnWidth(1,4000);//指定某列宽度(第几列,宽度)
c1.setCellStyle(tableStyle);
c1.setCellValue(contact.getUserName());
HSSFCell c2 = row.createCell(2);
c2.setCellStyle(tableStyle);
c2.setCellValue(contact.getSex());
*****
}
return wb;
}
//调用方法
HSSFWorkbook writer = createExcel(contactList);
try {
res.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8");
res.setHeader("Content-Disposition","attachment;filename=" + new String("name.xlsx".getBytes(StandardCharsets.UTF_8), StandardCharsets.ISO_8859_1));
writer.write(res.getOutputStream());
writer.close();
} catch (IOException e) {
e.printStackTrace();
}
Java 实现excel导出(无模板版)
最新推荐文章于 2023-05-06 16:20:53 发布