| | |
|---|
| | | package com.zy.asrs.controller; |
|---|
| | | |
|---|
| | | import com.alibaba.excel.EasyExcel; |
|---|
| | | import com.alibaba.excel.write.style.column.LongestMatchColumnWidthStyleStrategy; |
|---|
| | | import com.alibaba.fastjson.JSONArray; |
|---|
| | | import com.alibaba.fastjson.JSONObject; |
|---|
| | | import com.baomidou.mybatisplus.mapper.EntityWrapper; |
|---|
| | |
|---|
| | | response.setCharacterEncoding("utf-8"); |
|---|
| | | fileName = URLEncoder.encode(Cools.isEmpty(fileName)?"物料编码":fileName, "UTF-8"); |
|---|
| | | response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx"); |
|---|
| | | EasyExcel.write(response.getOutputStream(), MatCodeExcel.class).sheet("表1").doWrite(excels); |
|---|
| | | EasyExcel.write(response.getOutputStream(), MatCodeExcel.class) |
|---|
| | | .registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()) |
|---|
| | | .sheet("表1") |
|---|
| | | .doWrite(excels); |
|---|
| | | } |
|---|
| | | |
|---|
| | | // 导入 |
|---|
