Controller层
/**
* 导出excel
*/
@RequestMapping(value = "/loadExcel", method = RequestMethod.POST)
public void loadExcel(HttpServletResponse response) {
mallService.loadFlowsExcel(response);
}
Service层
public void loadFlowsExcel(HttpServletResponse response) {
//导出自己需要的数据列表 MallOrderDTO 类是我自己用的
List<MallOrderDTO> list = mallDao.getOrders(mallOrderDTO);
try {
HSSFWorkbook wb = new HSSFWorkbook();//创建HSSFWorkbook对象
HSSFSheet sheet = wb.createSheet("订单列表");//建立sheet对象
HSSFRow row1 = sheet.createRow(0); //在sheet里创建第一行,参数为行索引
HSSFCell cell = row1.createCell(0); //创建单元格
//标题
cell.setCellValue("订单列表");//设置单元格内容
CellStyle titleStyle = setHeaderStyle(wb);//设置单元格样式
cell.setCellStyle(titleStyle);
//合并单元格CellRangeAddress构造参数依次表示起始行,截至行,起始列, 截至列
sheet.addMergedRegion(new CellRangeAddress(0, 2, 0, 11));
/*------------导出excel的列名--------------*/
String[] cellValueArr = {
"订单ID", "商城名称", "商品名称", "订单价格(元)", "订单时间", "商品数量", "买家", "手机", "发货地址", "运费", "订单状态","付款状态"};
HSSFRow row2 = sheet.createRow(3);
//创建单元格并设置单元格,设置单元格的长度和格式
for (int i = 0; i < cellValueArr.length; i++) {
if (i == 2) {
sheet.setColumnWidth(i, 15 * 256 * 2);
} else if (i == 4) {
sheet.setColumnWidth(i, 15 * 256 * 2);
} else if (i == 8) {
sheet.setColumnWidth(i,