java使用poi的excel数据导出及线上预览

工作中经常会遇到需要从数据库中获取数据,整理后导出数据到excel中提供其他人员下载或者查看,整体功能并不复杂,今天提供一个基于poi工具+永中云预览的excel通用导出在线查看的方法

maven依赖:

        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>4.1.0</version>
        </dependency>

        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>4.1.0</version>
        </dependency>

Dto对象:

@Data
@NoArgsConstructor
public class OrderRecordUserDto {

    @ApiModelProperty(name = "用户ID")
    private String userId;

    @ApiModelProperty(name = "订单编号")
    private String id;

    @ApiModelProperty(hidden = true)
    private ProductType productType;

    @ApiModelProperty(name = "商品类型")
    private String productTypeCN;

    @ApiModelProperty(name = "订单信息")
    private String info;

    @ApiModelProperty(name = "实付金额(元)")
    private String amount;

    @ApiModelProperty(name = "订单创建时间")
    private Date createTime;

    @ApiModelProperty(name = "支付时间")
    private Date payTime;

    @ApiModelProperty(name = "订单状态")
    private String statusCN;
}

导出到ExcelUtil的工具方法:

//数据库表导出excel处理
    public static void exportInfo(List<?> list, InputStream inputStream, String name, String exportFilePath) {
        try {
            File exportFile = new File(exportFilePath);
            Workbook workBook;

            if (!exportFile.