/** * 初始化第一行的属性 * * @param workbook * @param propertyList * @param sheetName * @return */ private SXSSFSheet generateHeader(SXSSFWorkbook workbook, List<ExcelPropertyEntity> propertyList, String sheetName) { SXSSFSheet sheet = workbook.createSheet(sheetName); SXSSFRow headerRow = sheet.createRow(0); headerRow.setHeight((short) 600); CellStyle headCellStyle = getHeaderCellStyle(workbook); for (int i = 0; i < propertyList.size(); i++) { SXSSFCell cell = headerRow.createCell(i); cell.setCellStyle(headCellStyle); cell.setCellValue(propertyList.get(i).getColumnName()); calculateColumWidth(cell, i); } return sheet; }
targetRow.setHeight(sourceRow.getHeight());
sxssfRow.setHeight((short) (height * 2));