package com.taover.easyexcel.write.builder; import java.util.List; import com.taover.easyexcel.ExcelWriter; import com.taover.easyexcel.exception.ExcelGenerateException; import com.taover.easyexcel.write.metadata.WriteSheet; import com.taover.easyexcel.write.metadata.fill.FillConfig; /** * Build sheet * * @author Jiaju Zhuang */ public class ExcelWriterSheetBuilder extends AbstractExcelWriterParameterBuilder { private ExcelWriter excelWriter; /** * Sheet */ private WriteSheet writeSheet; public ExcelWriterSheetBuilder() { this.writeSheet = new WriteSheet(); } public ExcelWriterSheetBuilder(ExcelWriter excelWriter) { this.writeSheet = new WriteSheet(); this.excelWriter = excelWriter; } /** * Starting from 0 * * @param sheetNo * @return */ public ExcelWriterSheetBuilder sheetNo(Integer sheetNo) { writeSheet.setSheetNo(sheetNo); return this; } /** * sheet name * * @param sheetName * @return */ public ExcelWriterSheetBuilder sheetName(String sheetName) { writeSheet.setSheetName(sheetName); return this; } public WriteSheet build() { return writeSheet; } public void doWrite(List data) { if (excelWriter == null) { throw new ExcelGenerateException("Must use 'EasyExcelFactory.write().sheet()' to call this method"); } excelWriter.write(data, build()); excelWriter.finish(); } public void doFill(Object data) { doFill(data, null); } public void doFill(Object data, FillConfig fillConfig) { if (excelWriter == null) { throw new ExcelGenerateException("Must use 'EasyExcelFactory.write().sheet()' to call this method"); } excelWriter.fill(data, fillConfig, build()); excelWriter.finish(); } public ExcelWriterTableBuilder table() { return table(null); } public ExcelWriterTableBuilder table(Integer tableNo) { ExcelWriterTableBuilder excelWriterTableBuilder = new ExcelWriterTableBuilder(excelWriter, build()); if (tableNo != null) { excelWriterTableBuilder.tableNo(tableNo); } return excelWriterTableBuilder; } @Override protected WriteSheet parameter() { return writeSheet; } }