easyExcel导出练习

新建springboot项目pom导入依赖:

<!-- easyexcel 主要依赖  这一个基本上就够了-->
<dependency>
 <groupId>com.alibaba</groupId>
 <artifactId>easyexcel</artifactId>
 <version>2.1.4</version>
</dependency>
<!-- servlet-api -->
<dependency>
 <groupId>javax.servlet</groupId>
 <artifactId>javax.servlet-api</artifactId>
 <version>4.0.1</version>
 <scope>provided</scope>
</dependency>
<dependency>
 <groupId>com.alibaba</groupId>
 <artifactId>fastjson</artifactId>
 <version>1.2.47</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.projectlombok/lombok -->
<dependency>
 <groupId>org.projectlombok</groupId>
 <artifactId>lombok</artifactId>
 <version>1.18.12</version>
 <scope>provided</scope>
</dependency>
<!-- https://mvnrepository.com/artifact/com.alibaba/easyexcel -->
<dependency>
 <groupId>com.alibaba</groupId>
 <artifactId>easyexcel</artifactId>
 <version>2.2.6</version>
</dependency>

<groupId>com.alibaba</groupId>

<artifactId>easyexcel</artifactId>

</dependency>

<groupId>javax.servlet</groupId>

<artifactId>javax.servlet-api</artifactId>

<scope>provided</scope>

</dependency>

<groupId>com.alibaba</groupId>

<artifactId>fastjson</artifactId>

</dependency>

<groupId>org.projectlombok</groupId>

<artifactId>lombok</artifactId>

<scope>provided</scope>

</dependency>

<groupId>com.alibaba</groupId>

<artifactId>easyexcel</artifactId>

</dependency>

第二步:

新建实体:IndexData

package com.zxw.xiwen;

import com.alibaba.excel.annotation.ExcelProperty;
import lombok.Data;

import java.util.Date;

@Data
public class IndexData {
    @ExcelProperty(value = "字符串标题", index = 0)
    private String string;
    @ExcelProperty(value = "日期标题", index = 1)
    private Date date;
    /**
     * 这里设置3 会导致第二列空的
     */
    @ExcelProperty(value = "数字标题", index = 3)
    private Double doubleData;

package com.zxw.xiwen;

import com.alibaba.excel.annotation.ExcelProperty;

import lombok.Data;

import java.util.Date;

@Data

public class IndexData {

@ExcelProperty(value = "字符串标题", index = 0)

private String string;

@ExcelProperty(value = "日期标题", index = 1)

private Date date;

/**

* 这里设置3 会导致第二列空的

@ExcelProperty(value = "数字标题", index = 3)

private Double doubleData;

第三部:测试

@Test
void  importExcelTest(){
	// 写法2
	//fileName = TestFileUtil.getPath() + "simpleWrite" + System.currentTimeMillis() + ".xlsx";
	// 这里 需要指定写用哪个class去写
	ExcelWriter excelWriter = null;
	try {
		List<List<String>> data = new ArrayList<>();
		for (int i = 0; i < 100; i++) {
			List<String> item = new ArrayList<>();
			item.add("item0" + i);
			item.add("item1" + i);
			item.add("item2" + i);
			data.add(item);
		}
		excelWriter = EasyExcel.write("测试.xlsx", DemoData.class).build();
		WriteSheet writeSheet = EasyExcel.writerSheet("模板").build();
		excelWriter.write(data,writeSheet);
	} finally {
		// 千万别忘记finish 会帮忙关闭流
		if (excelWriter != null) {
			excelWriter.finish();
		}
	}
}

@Test

void importExcelTest(){

// 写法2

//fileName = TestFileUtil.getPath() + "simpleWrite" + System.currentTimeMillis() + ".xlsx";

// 这里需要指定写用哪个class去写

ExcelWriter excelWriter = null;

try {

List<List<String>> data = new ArrayList<>();

for (int i = 0; i < 100; i++) {

List<String> item = new ArrayList<>();

item.add("item0" + i);

item.add("item1" + i);

item.add("item2" + i);

data.add(item);

}

excelWriter = EasyExcel.write("测试.xlsx", DemoData.class).build();

WriteSheet writeSheet = EasyExcel.writerSheet("模板").build();

excelWriter.write(data,writeSheet);

} finally {

// 千万别忘记finish 会帮忙关闭流

if (excelWriter != null) {

excelWriter.finish();

}

Post Views: 428

一	二	三	四	五	六	日
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

easyExcel导出练习

Related Posts: