| | |
| | | |
| | | if(i==0){ |
| | | sheet.setColumnWidth(i, rowList.get(i).length() * 2 * 256); |
| | | // cell.setCellStyle(hstyle); |
| | | } |
| | | if(i==0 || j==0){ |
| | | cell.setCellStyle(hstyle); |
| | | }else if(j==0){ |
| | | }else{ |
| | | cell.setCellStyle(rowStyle); |
| | | } |
| | | } |
| | |
| | | configDataCellStyle.setAlignment(HorizontalAlignment.CENTER); |
| | | configDataCellStyle.setVerticalAlignment(VerticalAlignment.CENTER); |
| | | // 设置背景 |
| | | configDataCellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND); |
| | | configDataCellStyle.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex()); |
| | | // configDataCellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND); |
| | | // configDataCellStyle.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex()); |
| | | // 字体 |
| | | Font font = workbook.createFont(); |
| | | font.setFontHeightInPoints((short) 10); |
| | |
| | | // 边框 |
| | | configCellBorder(configDataCellStyle); |
| | | configDataCellStyle.setWrapText(true); |
| | | |
| | | return configDataCellStyle; |
| | | } |
| | | |