Example usage for org.apache.poi.hssf.usermodel HSSFSheet addMergedRegion

List of usage examples for org.apache.poi.hssf.usermodel HSSFSheet addMergedRegion

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.hssf.usermodel.*
  5. HSSFSheet
  6. addMergedRegion

Introduction

In this page you can find the example usage for org.apache.poi.hssf.usermodel HSSFSheet addMergedRegion.

Prototype

@Override
public int addMergedRegion(CellRangeAddress region)

Source Link

Document

Adds a merged region of cells on a sheet.

Usage

From source file:ua.com.ecotep.unianalysis.export.XLSDataExport.java

private void createHeaderCell(HSSFSheet sheet, int rnumber, String val, HSSFCellStyle cellStyleT) {
    HSSFRow row;//from   w w w.  jav  a 2s .c  om
    HSSFCell cell;
    row = sheet.createRow(rnumber);
    sheet.addMergedRegion(new CellRangeAddress(rnumber, rnumber, 0, 10));
    cell = row.createCell(0);
    cell.setCellValue(new HSSFRichTextString(val));
    cell.setCellStyle(cellStyleT);
}

From source file:Utility.TestReports.java

public void TestReports() {
    FileOutputStream out = null;/*from  w  ww. j  av  a 2  s. co  m*/
    Date myDate = new Date();
    SimpleDateFormat sm = new SimpleDateFormat("MM-dd-yyyy");
    String strDate = sm.format(myDate);
    HSSFWorkbook workbook = new HSSFWorkbook();
    HSSFSheet sheet = workbook.createSheet("Test Result");
    Row rowHeader1 = sheet.createRow((short) 0);
    rowHeader1.createCell(0).setCellValue("Test Step Id");
    Cell cell1 = rowHeader1.getCell((short) 0);
    setHeaderCellStyle(sheet, cell1, workbook);
    rowHeader1.createCell(1).setCellValue("Test Description");
    Cell cell2 = rowHeader1.getCell((short) 1);
    setHeaderCellStyle(sheet, cell2, workbook);
    rowHeader1.createCell(2).setCellValue("Expected Result");
    Cell cell3 = rowHeader1.getCell((short) 2);
    setHeaderCellStyle(sheet, cell3, workbook);
    rowHeader1.createCell(3).setCellValue("Actual Result");
    Cell cell4 = rowHeader1.getCell((short) 3);
    setHeaderCellStyle(sheet, cell4, workbook);
    rowHeader1.createCell(4).setCellValue("Error Details");
    Cell cell5 = rowHeader1.getCell((short) 4);
    setHeaderCellStyle(sheet, cell5, workbook);
    Row rowHeader = sheet.createRow((short) 1);
    Cell cellHeader1 = rowHeader.createCell((short) 0);
    sheet.addMergedRegion(new CellRangeAddress(1, 3, 0, 5));
    cellHeader1
            .setCellValue("Validate Disclaimer Acceptance - M1 Sign Up Page" + "  " + " Test Date : " + myDate);
    setHeaderCellStyle(sheet, cellHeader1, workbook);
    Row rowHeader2 = sheet.createRow((short) 7);
    Cell cellHeader2 = rowHeader2.createCell((short) 0);
    sheet.addMergedRegion(new CellRangeAddress(7, 9, 0, 5));
    cellHeader2.setCellValue("Validate User Account - M1 Sign Up Page" + "  " + " Test Date : " + myDate);
    setHeaderCellStyle(sheet, cellHeader2, workbook);
    Row rowHeader3 = sheet.createRow((short) 16);
    Cell cellHeader3 = rowHeader3.createCell((short) 0);
    sheet.addMergedRegion(new CellRangeAddress(16, 18, 0, 5));
    cellHeader3
            .setCellValue("Validate Business Information - M1 Sign Up Page" + "  " + " Test Date : " + myDate);
    setHeaderCellStyle(sheet, cellHeader3, workbook);
    Row rowHeader4 = sheet.createRow((short) 34);
    Cell cellHeader4 = rowHeader4.createCell((short) 0);
    sheet.addMergedRegion(new CellRangeAddress(34, 36, 0, 5));
    cellHeader4.setCellValue(
            "Validate Merchant Account Information - M1 Sign Up Page" + "  " + " Test Date : " + myDate);
    setHeaderCellStyle(sheet, cellHeader4, workbook);
}