๊ธฐํƒ€

Java POI .addMergedRegion

์• ์ •์“ฐ 2023. 7. 27. 13:35

๋ณ‘ํ•ฉํ•˜๋Š” ๋ฐฉ๋ฒ• ๊ธฐ๋ก

    CellRangeAddress region1 = new CellRangeAddress(0,0,1,2);
    sheet.addMergedRegion(region1);
    CellRangeAddress region2 = new CellRangeAddress(0,0,3,4);
    sheet.addMergedRegion(region2);
    CellRangeAddress region3 = new CellRangeAddress(0,0,5,6);
    sheet.addMergedRegion(region3);
    CellRangeAddress region4 = new CellRangeAddress(0,1,0,0);
    sheet.addMergedRegion(region4);

    Row row = sheet.createRow(0);
    Row bottomRow = sheet.createRow(1);
    final String[] headers = {"์„œ๋น„์Šค", "ํ•ด์ง€์‹ ์ฒญ","", "ํ•ด์ง€","", "์ค‘๋‹จ",""};
    final String[] subHeaders = {"", "๊ฑด์ˆ˜", "์ง์ „ ์›” ๋งค์ถœ", "๊ฑด์ˆ˜", "์ง์ „ ์›” ๋งค์ถœ", "๊ฑด์ˆ˜", "์ง์ „ ์›” ๋งค์ถœ"};
    int cellNum = 0;
    int bottomCellNum = 0;
    for (String header : headers) {
      Cell cell = row.createCell(cellNum++);
      cell.setCellValue(header);
    }
    for (String subHeader : subHeaders) {
      Cell bottomCell = bottomRow.createCell(bottomCellNum++);
      bottomCell.setCellValue(subHeader);
    }

 

๋ฐ˜์‘ํ˜•