public void OutFileToStream(HttpServletRequest request, HttpServletResponse response) throws Exception {
Workbook workbook = new Workbook();
WorksheetCollection worksheets = workbook.getWorksheets();
Worksheet worksheet = worksheets.get(0);
Cells cells = worksheet.getCells();
//设置标题样式
Style HeaderStyle = workbook.createStyle();
HeaderStyle.getFont().setBold(true); //文字加粗
HeaderStyle.setName("宋体"); //文字字体
HeaderStyle.getFont().setSize(13); //文字大小
HeaderStyle.setHorizontalAlignment(TextAlignmentType.CENTER);
HeaderStyle.setTextWrapped(true);//单元格内容自动换行
//设置内容样式
Style cellsStyle = workbook.createStyle();
cellsStyle.setHorizontalAlignment(TextAlignmentType.CENTER); //居中
HeaderStyle.setName("宋体"); //文字字体
HeaderStyle.getFont().setSize(12); //文字大小
cellsStyle.setTextWrapped(true);//单元格内容自动换行
for (int i = 0; i < 10; i++) {
cells.get(0, i).setValue("标题" + (i+1));
cells.get(0, i).setStyle(HeaderStyle);
cells.setRowHeight(0,25);
cells.setColumnWidth(i,25);
}
for (int i = 0; i < 10; i++) {
cells.get(1, i).setValue("哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈");
cells.get(1, i).setStyle(cellsStyle);
cells.setRowHeight(i, 20);
cells.setColumnWidth(i, 38);
}
String filename = "xxxxxx.xlsx";
try {
try {
filename = new String(filename.getBytes(), "ISO8859-1");
} catch (UnsupportedEncodingException e) {
e.printStackTrace();
}
response.setContentType("application/octet-stream;charset=ISO8859-1");
response.setHeader("Content-Disposition", "attachment;filename=" + filename);
response.addHeader("Pargam", "no-cache");
response.addHeader("Cache-Control", "no-cache");
workbook.save(response.getOutputStream(), SaveFormat.XLSX);
} catch (Exception ex) {
ex.printStackTrace();
}
}
ASPOSE.CELL FOR JAVA 导出Excel简单例子
最新推荐文章于 2024-08-08 07:19:07 发布