package com.tvs.controller;
import java.io.IOException;
import java.io.OutputStream;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.Font;
import org.apache.poi.ss.usermodel.IndexedColors;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
@Controller
@RequestMapping({"/excel"})
public class ExcelController
{
@RequestMapping(method={org.springframework.web.bind.annotation.RequestMethod.GET})
public void dewnExcel(HttpServletRequest request, HttpServletResponse response)
{
HSSFWorkbook wb = (HSSFWorkbook)createExcel();
try
{
response.setHeader("Content-Disposition", "attachment; filename=appointmentUser.xls");
response.setContentType("application/vnd.ms-excel; charset=utf-8");
OutputStream out = response.getOutputStream();
wb.write(out);
out.flush();
out.close();
}
catch (IOException e)
{
e.printStackTrace();
}
}
public Workbook createExcel()
{
Workbook wb = new HSSFWorkbook();
Sheet sheet = wb.createSheet("第一页");
for (int i = 0; i < 2; i++) {
sheet.setColumnWidth((short)i, 5355);
}
Row row = sheet.createRow(0);
CellStyle cs = wb.createCellStyle();
CellStyle cs2 = wb.createCellStyle();
Font f = wb.createFont();
Font f2 = wb.createFont();
f.setFontHeightInPoints((short)10);
f.setColor(IndexedColors.BLACK.getIndex());
f.setBoldweight((short)700);
f2.setFontHeightInPoints((short)10);
f2.setColor(IndexedColors.BLACK.getIndex());
cs.setFont(f);
cs.setBorderLeft((short)1);
cs.setBorderRight((short)1);
cs.setBorderTop((short)1);
cs.setBorderBottom((short)1);
cs.setAlignment((short)2);
cs2.setFont(f2);
cs2.setBorderLeft((short)1);
cs2.setBorderRight((short)1);
cs2.setBorderTop((short)1);
cs2.setBorderBottom((short)1);
cs2.setAlignment((short)2);
for (int i = 0; i < 2; i++)
{
Cell cell = row.createCell(i);
cell.setCellValue("张三" + i);
cell.setCellStyle(cs);
}
for (short i = 1; i < 2; i = (short)(i + 1))
{
Row row1 = sheet.createRow(i);
for (short j = 0; j < 2; j = (short)(j + 1))
{
Cell cell = row1.createCell(j);
cell.setCellValue("李四" + j);
cell.setCellStyle(cs2);
}
}
return wb;
}
}
springmvc下载excel大体步骤
最新推荐文章于 2024-06-26 14:04:09 发布