使用poi导入Excel并下载

@RestController
@RequestMapping({"/export"})
public class ExportExcelController {
public final static String PATH = "D:\\Export.xlsx";

@RequestMapping(value = "/doExportExcel", method = RequestMethod.POST)
//将数据传给前端
@ApiOperation("将文件转成流传给前端")
public ResponseEntity<byte[]> doExportExcel
(HttpServletRequest request) throws IOException {
//获取前端传来的result的json数据
String str = request.getParameter("result");
//调用函数
ArrayList<HashMap<String, Object>> arrayList = catchData(str);
//创建一个工作处
SXSSFWorkbook workbook = new SXSSFWorkbook();
//创建一个sheet页
SXSSFSheet sheet = workbook.createSheet();
sheet.setRandomAccessWindowSize(-1);
//定义当前行的初始值
int currentRow = 0;
int cnt;
Cell cell;
for (int i = 0; i < arrayList.size(); i+&#