下面简单给大家介绍poi导出配置
1.首先导入依赖
<dependency>
<groupid>org.apache.poi/<groupid>
<artifactid>poi/<artifactid>
<version>3.6/<version>
/<dependency>
2.创建工具类
package javaj.work.util;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.*;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletResponse;
import java.io.*;
import java.lang.reflect.Method;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
public class ExcelUtil {
//参数说明: fileName：文件名 projects：对象集合 columnNames： 列名 keys： map中的key
public static void start_download(HttpServletResponse response, String fileName, List> projects,
String[] columnNames, String[] keys) throws IOException {
//将集合中对象的属性 对应到 List
3.pojo
public class Student {
private int no;
private String name;
private int age;
//此处省略getter和setter
}
4.配置controller
@RequestMapping(value = "download")
public void index(HttpServletResponse response){
String fileName = "人员档案列表";
List<student> students = new ArrayList<student>();
for (int i = 0;i<20 ;i++){
Student student = new Student();
student.setAge(i+10);
student.setName("张三"+i);
student.setNo(i);
students.add(student);
}
// 列名
String columnNames[] = { "ID", "姓名", "年龄" };
// map中的key
String keys[] = { "no", "name", "age" };
try {
ExcelUtil.start_download(response, fileName, students,columnNames, keys);
} catch (IOException e) {
e.printStackTrace();
}
}
/<student>/<student>
5.页面
