demo如下:
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.*;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletResponse;
import java.io.OutputStream;
import java.io.UnsupportedEncodingException;
import java.util.List;
//上述是部分依赖
/** * 描述 导出数据表Excel * * @param response * @return * @author *** * @date *** */ @RequestMapping(value = "/dataExport", method = RequestMethod.GET) public void exportExcel(HttpServletResponse response) throws Exception { //获取数据列表 //MgrDataResultDto是自定义的实体bean List<MgrDataResultDto> list = queryListService.getDataList(); String[] title = {"序号", "部门", "源表名", "test01", "推荐名称", "匹配度", "test02", "test03", "test04", "状态