1.导包
pom文件导入
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>2.1.6</version>
</dependency>
2
import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.ExcelWriter;
import com.alibaba.excel.write.metadata.WriteSheet;
import com.alibaba.excel.write.style.column.SimpleColumnWidthStyleStrategy;
import com.alibaba.excel.write.style.row.SimpleRowHeightStyleStrategy;
import java.net.URLEncoder;
public class expertUti{
public static void export(HttpServletResponse response,List excelList,Class clazz,String fileName,String sheetName,Integer sheetNo){
try {
fileName = URLEncoder.encode("xxx.xlsx", "UTF-8");
response.setHeader("content-Type", "application/vnd.ms-excel;charset=utf-8");
response.addHeader("Content-Disposition", "attachment;filename=\"" + fileName+"\"");
ExcelWriter excelWriter = EasyExcel.write(response.getOutputStream())
.registerWriteHandler(new SimpleRowHeightStyleStrategy((short)15,(short)15))
.registerWriteHandler(new SimpleColumnWidthStyleStrategy(30)) // 设置宽度
.build();
WriteSheet sheetOrgTarget = EasyExcel.writerSheet(sheetNo, sheetName)
.head(clazz).build();
excelWriter.write(excelList, sheetOrgTarget);
excelWriter.finish();
} catch (Exception e) {
e.printStackTrace();
}
}
}