首先,在pom.xml里加poi的依赖,注意版本,我最开始用的3.09,出现了cloneSheet(0)等方法无法正确识别第一张分页的问题。
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.15</version>
</dependency>
暂时是保存到本地,用浏览器下载还没做好。
package excel;
import java.io.File;
...
@RestController
@RequestMapping("/excel")
public class ExcelController {
private static final Logger logger = LoggerFactory.getLogger(ExcelController.class);
HttpServletResponse response;
HttpServletRequest request;
@RequestMapping(value = "/", method = RequestMethod.GET)
public ApiResponse<Void> excel(HttpServletRequest request, HttpServletResponse response) {
this.request = request;
this.response = r