java后台导出Excel

约定不等于承诺〃 2021-12-20 22:34 325阅读 0赞

很久以前写的，可能有遗漏的配置。

一、加入包maven包

org.apache.poi

poi

3.14

二、java代码服务层

@SuppressWarnings(\{ "unchecked", "resource" \})

public void export(HttpServletRequest request, HttpSession session,

HttpServletResponse response, Map map) throws Exception \{

JSONObject json = getGzList(map);

//要导出的结果

List> resultList = (List>) json.get("resultList");

String stationName = map.get("stationName");

if(StringUtils.isNotEmpty(stationName)) \{

String\[\] temp = stationName.split("：");

stationName = temp.length>1?temp\[1\]:temp\[0\];

response.setContentType("application/vnd.ms-excel");

response.setHeader("content-disposition",

"attachment;filename=gzsheet.xls");

OutputStream fOut = null;

try \{

HSSFWorkbook wk = new HSSFWorkbook(); //工作簿

HSSFSheet sheet = wk.createSheet("Sheet1"); // 工作表

sheet.setColumnWidth(0, 5000);

sheet.setColumnWidth(1, 5000);

sheet.setColumnWidth(2, 8000);

sheet.setColumnWidth(3, 5000);

sheet.setColumnWidth(4, 15000);

HSSFCellStyle style = wk.createCellStyle(); // 样式对象

style.setVerticalAlignment(HSSFCellStyle.VERTICAL\_CENTER); // 垂直

style.setAlignment(HSSFCellStyle.ALIGN\_CENTER); // 水平

style.setWrapText(true);

style.setFillForegroundColor(HSSFColor.SKY\_BLUE.index);

HSSFFont font = wk.createFont();

font.setColor(HSSFColor.BLACK.index);// HSSFColor.VIOLET.index

// //字体颜色

font.setFontHeightInPoints((short) 20);

font.setBoldweight(HSSFFont.BOLDWEIGHT\_BOLD); // 字体增粗

//把字体应用到当前的样式

style.setFont(font);

HSSFCellStyle style1 = wk.createCellStyle(); // 创建单元格样式

style1.setWrapText(true);

style1.setVerticalAlignment(HSSFCellStyle.VERTICAL\_CENTER); // 垂直

style1.setAlignment(HSSFCellStyle.ALIGN\_LEFT); // 水平

HSSFFont font1 = wk.createFont();

font1.setFontHeightInPoints((short) 12);

font1.setBoldweight(HSSFFont.BOLDWEIGHT\_BOLD);

style1.setFont(font1);

HSSFCellStyle style2 = wk.createCellStyle();  // 创建单元格样式

style2.setWrapText(true);

style2.setVerticalAlignment(HSSFCellStyle.VERTICAL\_CENTER); // 垂直

style2.setAlignment(HSSFCellStyle.ALIGN\_LEFT); // 水平

HSSFFont font2 = wk.createFont();

font2.setFontHeightInPoints((short) 10);

style2.setFont(font2);

HSSFCellStyle style3 = wk.createCellStyle(); // 创建单元格样式

style3.setWrapText(true);

style3.setVerticalAlignment(HSSFCellStyle.VERTICAL\_CENTER); // 垂直

style3.setAlignment(HSSFCellStyle.ALIGN\_RIGHT);// 水平

HSSFFont font3 = wk.createFont();

font3.setFontHeightInPoints((short) 10);

style3.setFont(font3);

//第一行

HSSFRow row = sheet.createRow(0);

row.setHeightInPoints((short)50);

HSSFCell cell = row.createCell(0);

//sheet.addMergedRegion(new Region(0, (short) 0, 0, (short) 5));

sheet.addMergedRegion(new CellRangeAddress(0,0,0,4));

cell.setCellStyle(style);  // 样式，居中

cell.setCellValue("故障报表（"+ map.get("station") + "：" + stationName + "）");

for (int i = 0; i < resultList.size(); i++) \{

row = sheet.createRow(i+1); // 第i行

row.setHeightInPoints((short)20);

Map m = resultList.get(i);

cell = row.createCell(0);

cell.setCellValue(m.get("BT").toString());

cell.setCellStyle(style1);

cell = row.createCell(1);

cell.setCellValue(m.get("COUN").toString());

cell.setCellStyle(style3);

cell = row.createCell(2);

cell.setCellValue(m.get("DESCRIPTION").toString());

cell.setCellStyle(style1);

cell = row.createCell(3);

cell.setCellValue(m.get("CXSJ").toString());

cell.setCellStyle(style2);

cell = row.createCell(4);

cell.setCellValue(m.get("SJ").toString());

cell.setCellStyle(style2);

fOut = response.getOutputStream();

wk.write(fOut);

fOut.flush();

\} catch (Exception e) \{

e.printStackTrace();

\} finally \{

fOut.close();

转载于:https://www.cnblogs.com/ygkeke/p/10874240.html

java后台导出Excel

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 java导出Excel.

相关 java 数据导出Excel java POI 导出数据Excel

相关 java后台导出excel，客户端下载

相关 java 导出excel

相关 Java导出excel

相关 java 导出excel

相关 java导出Excel

相关 excel Java 导出

相关 java后台导出Excel

相关 struts2导出excel java 导出excel