Spring Boot实战之导出excel，并上传存入Azure Storage

Spring Boot实战之导出excel

本文使用Apache POI实现excel文档的导出。 实现从数据库读取数据——生成excel——上传到AzureStorage的流程

数据库操作，及文件上传AzureStorage的流程可以参考之前的文章

http://blog.youkuaiyun.com/sun_t89/article/details/51912905

http://blog.youkuaiyun.com/sun_t89/article/details/51956392

Apache POI详细操作，可以参考

http://www.cnblogs.com/LiZhiW/p/4313789.html?utm_source=tuicool&utm_medium=referral

1、修改pom.xml，添加Apache POI库

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

2、添加导出数据表的数据模型

package com.xiaofangtech.sunt.bean;

import java.math.BigDecimal;
import java.util.Date;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name="t_statistics")
public class StatisticsInfo {
	@Id
	@GeneratedValue(strategy = GenerationType.AUTO)
	private long id;
	private BigDecimal money;
	private String description;
	private Date currentdate;
	public long getId() {
		return id;
	}
	public void setId(long id) {
		this.id = id;
	}
	public BigDecimal getMoney() {
		return money;
	}
	public void setMoney(BigDecimal money) {
		this.money = money;
	}
	public String getDescription() {
		return description;
	}
	public void setDescription