| | |
| | | int column = 0; |
| | | if(index == 0) { |
| | | // 合并第一行的前5个单元格 |
| | | sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 7)); |
| | | sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 6)); |
| | | |
| | | // 创建行并设置高度 |
| | | row = sheet.createRow(0); |
| | | row.setHeight((short)(40 * 40)); |
| | | row.setHeight((short)(20 * 20)); |
| | | |
| | | |
| | | // sheet.addMergedRegion(new CellRangeAddress(1, 1, 0, 7)); |
| | |
| | | CellStyle style = wb.createCellStyle(); |
| | | Font font = wb.createFont(); |
| | | font.setBold(true); |
| | | font.setFontHeightInPoints((short) 12); |
| | | |
| | | font.setFontName("宋体"); |
| | | style.setFont(font); |
| | | style.setAlignment(HorizontalAlignment.CENTER); |
| | |
| | | row = sheet.createRow(1); |
| | | // |
| | | row.createCell(0).setCellValue("ISO编号:"); |
| | | row.createCell(1).setCellValue(list.get(0).getIos5()); |
| | | // row.createCell(4).setCellValue("档号:"); |
| | | //拿到档号 |
| | | row.createCell(5).setCellValue(""); |