poi to excel

最新推荐文章于 2024-06-26 19:21:55 发布

YYLJ2ee

最新推荐文章于 2024-06-26 19:21:55 发布

阅读量111

点赞数

分类专栏： J2SE 文章标签： Excel Apache 工作

本文链接：https://blog.csdn.net/YYLJ2ee/article/details/83287312

版权

J2SE 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

import="org.apache.poi.hssf.usermodel.HSSFCell"
import="org.apache.poi.hssf.usermodel.HSSFRow"
import="org.apache.poi.hssf.usermodel.HSSFSheet"
import="org.apache.poi.hssf.usermodel.HSSFWorkbook"
import="org.apache.poi.hssf.usermodel.HSSFCellStyle"
import="org.apache.poi.hssf.util.Region"

http://poi.apache.org/

response.reset();
response.setHeader("Content-Disposition","attachment; filename=difference.csv");
response.setContentType("application/vnd.ms-excel");
//工作簿:HSSFWorkbook
HSSFWorkbook wb = new HSSFWorkbook();
//工作表:HSSFSheet("表名")
HSSFSheet sheet = wb.createSheet("工作表名");
//合并單元格Region(int rowFrom, short colFrom, int rowTo, short colTo)
sheet.addMergedRegion(new Region(0, (short) 0, 0, (short) 6));
//單元格樣式HSSFCellStyle
HSSFCellStyle cellStyle = wb.createCellStyle();
cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
//行HSSFRow
HSSFRow row = sheet.createRow(0);//從0開始
row.setHeight((short)500);
//單元格HSSFCell
HSSFCell cell = row.createCell((short)0);
//將單元格編碼設utf-16
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue(titleHead);
cell.setCellStyle(cellStyle);
cellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN);

cellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN);
//顏色
cellStyle.setFillBackgroundColor(HSSFColor.AQUA.index);
cellStyle.setFillPattern(HSSFCellStyle.BIG_SPOTS);
cellStyle.setFillForegroundColor(HSSFColor.ORANGE.index);
cellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);

row = sheet.createRow(1);
cell = row.createCell((short)0);cell.setEncoding(HSSFCell.ENCODING_UTF_16);cell.setCellValue("col one ");
.............

wb.write(response.getOutputStream());