public String dowmExcelThrowBrowser(HttpServletResponse response) throws IOException {
HSSFWorkbook hssfWorkbook = new HSSFWorkbook();//创建一个文档类
HSSFSheet hssfSheet = hssfWorkbook.createSheet("测试表格1");//创建一个工作簿
// 设置excel每列宽度
hssfSheet.setColumnWidth(0, 4000);
hssfSheet.setColumnWidth(1, 3500);
// 创建字体样式
HSSFFont font = hssfWorkbook.createFont();
font.setFontName("Verdana");
font.setBoldweight((short) 100);
font.setFontHeight((short) 300);
font.setColor(HSSFColor.BLUE.index);
// 创建单元格样式
HSSFCellStyle style = hssfWorkbook.createCellStyle();
style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
style.setFillForegroundColor(HSSFColor.LIGHT_TURQUOISE.index);
style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
// 设置边框
style.setBottomBorderColor(HSSFColor.RED.index);
style.setBorderBottom(HSSFCellStyle.BORDER_THIN);
style.setBorderLeft(HSSFCellStyle.BORDER_THIN);
style.setBorderRight(HSSFCellStyle.BORDER_THIN);
style.setBorderTop(HSSFCellStyle.BORDER_THIN);
style.setFont(font);// 设置字体
//设置头部
HSSFRow headRow = hssfSheet.createRow(0);//设置第一行为表头
String[] head = {"语文","代数","几何","物理","化学","英语","生物","历史","地理","政治"};
for (int i = 0; i < head.length; i++) {
HSSFCell hssfCell = headRow.createCell(i);//创建一行里的一列
// 给Excel的单元格设置样式和赋值
hssfCell.setCellStyle(style);
hssfCell.setCellValue(head[i]);
}
for (int i = 1; i < 10; i++) {
HSSFRow bodyRow = hssfSheet.createRow(i);//创建一行
for (int k = 0; k < 10; k++) {
HSSFCell hssfCell = bodyRow.createCell(k);//创建一行里的一列
// 给Excel的单元格设置样式和赋值
hssfCell.setCellStyle(style);
hssfCell.setCellValue(new Random().nextInt(100));
}
}
SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyyMMddhhmmss");
String timeString = simpleDateFormat.format(new Date());
response.setContentType("application/ms-excel;");
response.setHeader("Content-Disposition", new String(("attachment;filename="+timeString+".xls").getBytes("GB2312"), "UTF-8"));
OutputStream out = response.getOutputStream();
hssfWorkbook.write(out);
out.close();
return "excel down throw Browser";
}
java excel通过浏览器下载
最新推荐文章于 2023-12-15 15:24:56 发布