springboot接入poi
一、POI是什么
POI提供API给Java程序对Microsoft Office格式档案读和写的功能。比较常见的是对excel的操作。
二、POI的简单使用
Springboot+用poi实现Excel的导入导出
1、Excel导入,即读取Excel内容存入数据库或其他地方。此处我仅仅将其Excel内容读取后,打印到控制台。
2、Excel导出,即通过将对象生成Excel表返回给用户。
三、代码如下:
1、引入依赖
<!-- https://mvnrepository.com/artifact/org.apache.poi/poi -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.17</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.17</version>
</dependency>
2、写一个Service接口
package com.haibo.base.service;
import org.springframework.http.ResponseEntity;
import org.springframework.web.multipart.MultipartFile;
import javax.servlet.http.HttpServletResponse;
public interface PoiService {
/**
* 上传/导入
* @param file
* @return
*/
ResponseEntity fileUpload(MultipartFile file);
/**
* 下载/导出
* @param response
*/
void downLoadExcel(HttpServletResponse response);
}
3、实现功能
提供一个假数据源:
package com.haibo.base.dao;
import com.haibo.base.entity.Teacher;
import org.springframework.stereotype.Component;
import java.util.ArrayList;
import java.util.List;
/**
* @author:haibo.xiong
* @date:2019/5/7
* @description:
*/
@Component
public class PoiDaoImpl implements PoiDao{
@Override
public List<Teacher> getTeachers() {
List<Teacher> classmateList= new ArrayList<>();
classmateList.add(new Teacher("1","张三","1","123456"));
classmateList.add(new Teacher("2","李四","1","123456"));
classmateList.add(new Teacher("3","王五","2","123456"));
classmateList.add(new Teacher("4","赵六",&#