예제 #1
0
  public void testGetSetColDefaultStyle() {
    XSSFWorkbook workbook = new XSSFWorkbook();
    XSSFSheet sheet = workbook.createSheet();
    CTWorksheet ctWorksheet = sheet.getCTWorksheet();
    ColumnHelper columnHelper = sheet.getColumnHelper();

    // POI column 3, OOXML column 4
    CTCol col = columnHelper.getOrCreateColumn1Based(4, false);

    assertNotNull(col);
    assertNotNull(columnHelper.getColumn(3, false));
    columnHelper.setColDefaultStyle(3, 2);
    assertEquals(2, columnHelper.getColDefaultStyle(3));
    assertEquals(-1, columnHelper.getColDefaultStyle(4));
    StylesTable stylesTable = workbook.getStylesSource();
    CTXf cellXf = CTXf.Factory.newInstance();
    cellXf.setFontId(0);
    cellXf.setFillId(0);
    cellXf.setBorderId(0);
    cellXf.setNumFmtId(0);
    cellXf.setXfId(0);
    stylesTable.putCellXf(cellXf);
    CTCol col_2 = ctWorksheet.getColsArray(0).addNewCol();
    col_2.setMin(10);
    col_2.setMax(12);
    col_2.setStyle(1);
    assertEquals(1, columnHelper.getColDefaultStyle(11));
    XSSFCellStyle cellStyle = new XSSFCellStyle(0, 0, stylesTable, null);
    columnHelper.setColDefaultStyle(11, cellStyle);
    assertEquals(0, col_2.getStyle());
    assertEquals(1, columnHelper.getColDefaultStyle(10));
  }
예제 #2
0
  public void testGetOrCreateColumn() {
    XSSFWorkbook workbook = new XSSFWorkbook();
    XSSFSheet sheet = workbook.createSheet("Sheet 1");
    ColumnHelper columnHelper = sheet.getColumnHelper();

    // Check POI 0 based, OOXML 1 based
    CTCol col = columnHelper.getOrCreateColumn1Based(3, false);
    assertNotNull(col);
    assertNull(columnHelper.getColumn(1, false));
    assertNotNull(columnHelper.getColumn(2, false));
    assertNotNull(columnHelper.getColumn1Based(3, false));
    assertNull(columnHelper.getColumn(3, false));

    CTCol col2 = columnHelper.getOrCreateColumn1Based(30, false);
    assertNotNull(col2);
    assertNull(columnHelper.getColumn(28, false));
    assertNotNull(columnHelper.getColumn(29, false));
    assertNotNull(columnHelper.getColumn1Based(30, false));
    assertNull(columnHelper.getColumn(30, false));
  }