easyexcel
easyexcel copied to clipboard
写csv文件设置分隔符
官网上搜索csv相关,只查到读取时设置分隔符。 请问是否支持写csv文件设置分隔符?如果支持,如何调用?
#2559 看这个issue应该是还不支持,你可以自定义writeHandler,下面是我写的
public class CustomDelimiterHandler implements RowWriteHandler {
private char delimiter;
public CustomDelimiterHandler(char delimiter) {
this.delimiter = delimiter;
}
public void beforeRowCreate(RowWriteHandlerContext context) {
Workbook workbook = context.getWriteWorkbookHolder().getWorkbook();
if (workbook instanceof CsvWorkbook) {
CsvWorkbook csvWorkbook = (CsvWorkbook) workbook;
CsvSheet csvSheet = csvWorkbook.getCsvSheet();
csvSheet.setCsvFormat(csvSheet.getCsvFormat().withDelimiter(delimiter));
}
}
}
The latest version of FastExcel will support this feature. Please take a look at this FastExcel-PR-353.