in shardingsphere-benchmark/src/main/java/org/apache/shardingsphere/benchmark/common/file/excel/BenchmarkExcelWriter.java [160:190]
private static Workbook buildDataSheet(Workbook result, String sheetName, boolean isHeader, int rowNum, List<BenchmarkResultBean> dataList) {
Sheet sheet = null;
if(null == result.getSheet(sheetName)){
sheet = result.createSheet(sheetName);
} else {
sheet = result.getSheet(sheetName);
}
CellStyle cellStyle = buildHeadCellStyle(sheet.getWorkbook());
if(isHeader){
for (int i=0; i < CELL_HEADS.size(); i++) {
sheet.setColumnWidth(i, 6000);
}
sheet.setDefaultRowHeight((short) 400);
Row head = sheet.createRow(0);
for (int i = 0; i < CELL_HEADS.size(); i++) {
Cell cell = head.createCell(i);
cell.setCellValue(CELL_HEADS.get(i));
cell.setCellStyle(cellStyle);
}
}
for (int i = 0; i < dataList.size(); i++) {
BenchmarkResultBean benchmarkResultBean = dataList.get(i);
Row row = sheet.createRow(rowNum++);
convertDataToRow(benchmarkResultBean, row);
}
return result;
}