easyExcel导出参数表头

easyExcel导出参数表头
依赖

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>easyexcel</artifactId>
    <version>3.1.1</version>
</dependency>

导出类

@Data
public class ExportExcel implements Serializable {
	private static final long serialVersionUID = 1L;

	@ExcelProperty(value = {"${cellWriterValue}", "序号"})
	private Integer sort;

	@ExcelProperty(value = {"${cellWriterValue}", "条码号"})
	private String barcode;
}

参数表头处理器

public class ValueCellWriteHandler implements CellWriteHandler {

	private String cellWriterValue;
	PropertyPlaceholderHelper propertyPlaceholderHelper = new PropertyPlaceholderHelper("${","}");

	public ValueCellWriteHandler(String cellValue) {
		this.cellWriterValue = cellValue;
	}

	@Override
	public void beforeCellCreate(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder, Row row, Head head, Integer integer, Integer integer1, Boolean aBoolean) {
		if (null != head) {
			List<String> headNameList = head.getHeadNameList();
			if (CollectionUtil.isNotEmpty(headNameList)) {
				Properties properties = new Properties();
				properties.setProperty("cellWriterValue", cellWriterValue);
				for (int i = 0; i < headNameList.size(); i++) {
					headNameList.set(i, propertyPlaceholderHelper.replacePlaceholders(headNameList.get(i), properties));
				}
			}
		}
	}
}

导出(我这里是上传到文件存储去了)

public String exportExcel(String value) {
	List<ExportExcel> excelList = new ArrayList<>();
	ByteArrayOutputStream out = new ByteArrayOutputStream();
	ExcelWriter excelWriter = null;
	try {
		excelWriter = EasyExcel.write(out, ExportExcel.class)
			.registerWriteHandler(new ValueCellWriteHandler(value)).build();
		WriteSheet writeSheet = EasyExcel.writerSheet(0, value).build();
		excelWriter.write(excelList, writeSheet);
	} finally {
		if (excelWriter != null) {
			excelWriter.finish();
		}
	}
	File file = ossTemplate.putFile("fileName", new ByteArrayInputStream(out.toByteArray()));
	return file.getLink();
}

效果(“参数”便是上面exportExcel()方法传入的value)

参考自：https://blog.csdn.net/lol19950605/article/details/135776897?spm=1001.2014.3001.5502