java 使用POI简单excel表格导出，通过浏览器直接下载

最新推荐文章于 2022-09-30 15:04:47 发布

凱凱啊

最新推荐文章于 2022-09-30 15:04:47 发布

阅读量1k

点赞数 1

分类专栏： java POI 文章标签： java poi

本文链接：https://blog.csdn.net/weixin_44018367/article/details/121414840

版权

pom.xl依赖

<!--POI Excel表格导出依赖-->
<dependency>
	<groupId>org.apache.poi</groupId>
	<artifactId>poi-ooxml</artifactId>
	<version>3.17</version>
</dependency>

导出代码：

import com.api.ms.flower.action.dto.WithdrawMoneyDTO;
import com.api.ms.flower.action.exception.CommonExceptionStatus;
import com.api.ms.flower.action.log.Operations;
import com.api.ms.flower.action.service.RemitAccountService;
import com.api.ms.flower.action.vo.Result;
import io.swagger.annotations.ApiImplicitParam;
import io.swagger.annotations.ApiImplicitParams;
import io.swagger.annotations.ApiOperation;
import org.apache.commons.lang3.StringUtils;
import org.apache.poi.xssf.usermodel.*;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.validation.constraints.NotBlank;
import javax.validation.constraints.Size;
import java.io.IOException;
import java.io.OutputStream;
import java.io.UnsupportedEncodingException;
import java.math.BigDecimal;
import java.net.URLEncoder;
import java.sql.Timestamp;
import java.text.DateFormat;
import java.text.ParseExcept