使⽤esaypoi动态⽣成列导出
引⼊easypoi依赖
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-base</artifactId>
<version>4.1.0</version>
</dependency>
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-annotation</artifactId>
<version>4.1.0</version>
</dependency>
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-web</artifactId>
<version>4.1.0</version>
</dependency>
ExcelExportUtils：
import cn.l.ExcelExportUtil;
import cn.l.entity.ExportParams;
import cn.us.ExcelType;
import cn.l.entity.params.ExcelExportEntity;
import cn.l.export.ExcelExportService;
slf4j.Slf4j;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Workbook;
import java.io.File;
import java.io.FileOutputStream;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
@Slf4j
public class ExcelExportUtils {
/**
* 选择列导出（单sheet）
* @param fileNameUrl ⽂件导出服务器路径
* @param sheetName sheet名称
* @param dataList 数据list（map封装）
* @param excelRows 导出的选择的列
* @param title 标题(为空就传null)
*/
public static void exportExcel(String fileNameUrl, String sheetName, List<Map<String,Object>> dataList, List<ExcelExportDTO> excelRows, String title) t hrows Exception{
// 使⽤easypoi中的ExcelExportEntity对象存储要导出的列
List<ExcelExportEntity> entityList =new ArrayList<>();
excelRows.forEach(item->{
ExcelExportEntity exportEntity =new LineName(), FieldName());
exportEntity.Height());
exportEntity.Width());
entityList.add(exportEntity);
});
// 执⾏⽅法
ExportParams exportParams =new ExportParams(null, sheetName, ExcelType.XSSF);
Workbook workbook = portExcel(exportParams, entityList ,dataList);
String fileName = fileNameUrl;
File file =new File(fileName);
try{
FileOutputStream fout =new FileOutputStream(file);
FileOutputStream fout =new FileOutputStream(file);
workbook.write(fout);
fout.close();
}catch(Exception e){
<("导出失败-----------------------------------");
throw new Exception("导出失败！");
}
}
/
**
* 多sheet导出
* @param fileNameUrl ⽂件导出服务器路径
* @param multiSheetDTOList 多sheet中的属性
*/
public static void exportMultiSheetExcel(String fileNameUrl, List<MultiSheetDTO> multiSheetDTOList) throws Exception{
try{
Workbook workbook =new HSSFWorkbook();
// 遍历sheet
for(MultiSheetDTO multiSheetDTO:multiSheetDTOList){
ExcelExportService server =new ExcelExportService();
ExportParams exportParams =new Title(), SheetName(), ExcelType.XSSF);                List<ExcelExportEntity> entityList =new ArrayList<>();
ExcelExportEntity exportEntity =new LineName(), FieldName());
exportEntity.Height());
exportEntity.Width());
entityList.add(exportEntity);
});
}
FileOutputStream fos =new FileOutputStream(fileNameUrl);
workbook.write(fos);
fos.close();
}catch(Exception e){
<("导出失败-----------------------------------");
throw new Exception("导出失败！");
}
}
public static void main(String[] args){
String fileNameUrl ="C:/Users/liufenglian9212/Desktop/⼯作⽂档/价格分析表.xls";
List<Map<String,Object>> dataList =new ArrayList<>();
Map<String,Object> data =new HashMap<>();
data.put("goodsName","奥特曼玩具");
/* data.put("goodsNum","2");*/
dataList.add(data);
List<ExcelExportDTO> excelRows =new ArrayList<>();
ExcelExportDTO excelExportDTO =new ExcelExportDTO();
excelExportDTO.setFieldName("goodsName");
excelExportDTO.setLineName("商品名称");
/*  ExcelExportDTO excelExportDTO1 = new ExcelExportDTO();
excelExportDTO1.setFieldName("goodsNum");
excelExportDTO1.setLineName("商品數量");
excelRows.add(excelExportDTO1);*/
excelRows.add(excelExportDTO);
String title ="test";
try{
exportExcel(fileNameUrl,"test",dataList,excelRows,title);
}catch(Exception e){
System.out.println(e);
}
}
}
ExcelExportDTO：
public class ExcelExportDTO {
private String lineName;
private String fieldName;
private Double width =20D;
private Double height =10D;
public ExcelExportDTO(){}
public ExcelExportDTO(String lineName, String fieldName){
this.lineName = lineName;
this.fieldName = fieldName;
}
public ExcelExportDTO(String lineName, String fieldName, Double width, Double height){ this.lineName = lineName;
this.fieldName = fieldName;
this.width = width;
this.height = height;
}
public String getLineName(){
return lineName;
}
public void setLineName(String lineName){
this.lineName = lineName;
}
public String getFieldName(){
return fieldName;
}
public void setFieldName(String fieldName){
this.fieldName = fieldName;
}
public Double getWidth(){
return width;
}
public void setWidth(Double width){
this.width = width;
}
public Double getHeight(){
return height;
}
public void setHeight(Double height){
this.height = height;
}
}
MultiSheetDTO：
import java.util.List;
import java.util.Map;
public class MultiSheetDTO {
/**
* sheet名称
*/
private String sheetName;
/**
* 导出数据
*/
private List<Map<String,Object>> dataList;
/**
* 导出列属性
*/
private List<ExcelExportDTO> excelRows;
/
**
* title
*/
private String title;
public String getSheetName(){
return sheetName;
}
public void setSheetName(String sheetName){
this.sheetName = sheetName;
}
public List<Map<String, Object>>getDataList(){
return dataList;
}
public void setDataList(List<Map<String, Object>> dataList){
this.dataList = dataList;
}
public List<ExcelExportDTO>getExcelRows(){
return excelRows;
}
public void setExcelRows(List<ExcelExportDTO> excelRows){
}
public String getTitle(){
return title;
}
public void setTitle(String title){
this.title = title;
}
}
ps：主要使⽤easypoi的cn.l.entity.params.ExcelExportEntityparam name

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。