Excel导出

导出 excel

package com.buba.controller;

import com.buba.model.Trim;
import com.buba.service.TrimService;
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.ss.usermodel.CellValue;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.net.URLEncoder;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;

/**
 * @ClassName TrimExcelController
 * @Description 任务调度信息管理导出
 * @Author 东阳
 * @Date 2019/10/24 11:04
 */
@RestController
@RequestMapping("/partyMetting")
public class TrimExcelController {
    @Resource
    private TrimService trimService;
    @RequestMapping(value = "TrimExcelDownloads", method = RequestMethod.GET)
    public void downloadAllClassmate(HttpServletResponse response) throws IOException {


        HSSFWorkbook workbook = new HSSFWorkbook();

        HSSFDataFormat format = workbook.createDataFormat();





        HSSFSheet sheet = workbook.createSheet("信息表");


        List<Trim> classmateList = trimService.triminfor();
        System.out.println(trimService.triminfor());
        SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        String fileName = "任务调度信息管理"+df.format(new Date());



        //新增数据行，并且设置单元格数据


        int rowNum = 1;

        String[] headers = { "源系统", "任务状态", "生效日期", "失效日期", "任务名称", "源系统数据源", "目标系统", "目标系统数据源","目标系统数据的加载式"};
        //headers表示excel表中第一行的表头

        HSSFRow row = sheet.createRow(0);
        //在excel表中添加表头
        for(int i=0;i<headers.length;i++){
            HSSFCell cell = row.createCell(i);
            HSSFRichTextString text = new HSSFRichTextString(headers[i]);
            cell.setCellValue(text);
            HSSFCellStyle cellStyle = workbook.createCellStyle();
            sheet.setColumnWidth(i, "headers".getBytes().length*2*450);
        }

        //在表中存放查询到的数据放入对应的列
        for (Trim trim : classmateList) {

            HSSFRow row1 = sheet.createRow(rowNum);
            row1.createCell(0).setCellValue(trim.getOriginalSystem());
            row1.createCell(1).setCellValue(trim.getState());
            row1.createCell(2).setCellValue(trim.getTakeEffect());
            row1.createCell(3).setCellValue(trim.getLoseEfficacy());
            row1.createCell(4).setCellValue(trim.getTakeName());
            row1.createCell(5).setCellValue(trim.getOriginalSystemOrigin());
            row1.createCell(6).setCellValue(trim.getTargetSystem());
            row1.createCell(7).setCellValue(trim.getTargetSystemOrigin());
            row1.createCell(8).setCellValue(trim.getTargetSystemLoad());
            rowNum++;
        }


        response.setContentType("application/octet-stream;charset=utf-8");
        response.setHeader("Content-Disposition", "attachment;filename=" + new String(fileName.getBytes(),"iso-8859-1") + ".xls");

        response.flushBuffer();
        workbook.write(response.getOutputStream());
    }
}

html页面

<btn:permission type="0" code="1010105">
     <button id="btn_set" onclick="set();" type="button" class="btn btn-sm btn-link" ><span class="glyphicon glyphicon-cog" aria-hidden="true"></span> <b>导出</b></button>
</btn:permission>

js

function set() {
            window.location.href="/partyMetting/TrimExcelDownloads";
        }