test.java
1.2 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
package com.framework.excel;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.util.ArrayList;
import java.util.List;
public class test {
public static void main(String[] args) {
// 初始化数据
List<TestEntity> list = new ArrayList<TestEntity>();
TestEntity vo = new TestEntity();
vo.setId(1);
vo.setName("李坤");
vo.setAge(26);
vo.setClazz("五期提高班");
vo.setCompany("天融信");
list.add(vo);
TestEntity vo1 = new TestEntity();
vo1.setId(1);
vo1.setName("李坤");
vo1.setAge(26);
vo1.setClazz("五期提高班");
vo1.setCompany("天融信");
list.add(vo1);
TestEntity vo2 = new TestEntity();
vo2.setId(1);
vo2.setName("李坤");
vo2.setAge(26);
vo2.setClazz("五期提高班");
vo2.setCompany("天融信");
list.add(vo2);
FileOutputStream out = null;
try {
out = new FileOutputStream("D:\\success3.xls");
} catch (FileNotFoundException e) {
e.printStackTrace();
}
ExcelUtil<TestEntity> util = new ExcelUtil<TestEntity>(TestEntity.class); // 创建工具类.
util.exportExcel(list, "学生信息", out); // 导出
System.out.println("----执行完毕----------");
}
}