Examples of org.apache.poi.xssf.usermodel.XSSFCellStyle

org.apache.poi.xssf.usermodel.XSSFCellStyle
High level representation of the the possible formatting information for the contents of the cells on a sheet in a SpreadsheetML document. @see org.apache.poi.xssf.usermodel.XSSFWorkbook#createCellStyle() @see org.apache.poi.xssf.usermodel.XSSFWorkbook#getCellStyleAt(short) @see org.apache.poi.xssf.usermodel.XSSFCell#setCellStyle(org.apache.poi.ss.usermodel.CellStyle)

    // 0 is the empty default
    if(xfs.get(idx).getXfId() > 0) {
      styleXfId = (int) xfs.get(idx).getXfId();
    }


    return new XSSFCellStyle(idx, styleXfId, this, theme);
  }

View Full Code Here

    xf.setFillId(0);
    xf.setBorderId(0);
    xf.setXfId(0);
    int xfSize = styleXfs.size();
    int indexXf = putCellXf(xf);
    return new XSSFCellStyle(indexXf - 1, xfSize - 1, this, theme);
  }

View Full Code Here

    // 0 is the empty default
    if(xfs.get(idx).getXfId() > 0) {
      styleXfId = (int) xfs.get(idx).getXfId();
    }


    return new XSSFCellStyle(idx, styleXfId, this);
  }

View Full Code Here

        xf.setFillId(0);
        xf.setBorderId(0);
        xf.setXfId(0);
        int xfSize = styleXfs.size();
        int indexXf = putCellXf(xf);
        return new XSSFCellStyle(indexXf - 1, xfSize - 1, this);
    }

View Full Code Here

    
    int nf1 = st.putNumberFormat("yyyy-mm-dd");
    int nf2 = st.putNumberFormat("yyyy-mm-DD");
    assertEquals(nf1, st.putNumberFormat("yyyy-mm-dd"));
    
    st.putStyle(new XSSFCellStyle(st));
    
    // Save and re-load
    st = XSSFTestDataSamples.writeOutAndReadBack(wb).getStylesSource();


    assertNotNull(st.getCTStylesheet());

View Full Code Here

        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);
        columnHelper.setColDefaultStyle(11, cellStyle);
        assertEquals(0, col_2.getStyle());
        assertEquals(1, columnHelper.getColDefaultStyle(10));
    }

View Full Code Here

        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);
        columnHelper.setColDefaultStyle(11, cellStyle);
        assertEquals(0, col_2.getStyle());
        assertEquals(1, columnHelper.getColDefaultStyle(10));
    }

View Full Code Here

    // 0 is the empty default
    if(xfs.get(idx).getXfId() > 0) {
      styleXfId = (int) xfs.get(idx).getXfId();
    }


    return new XSSFCellStyle(idx, styleXfId, this);
  }

View Full Code Here

    xf.setFillId(0);
    xf.setBorderId(0);
    xf.setXfId(0);
    int xfSize = styleXfs.size();
    int indexXf = putCellXf(xf);
    return new XSSFCellStyle(indexXf - 1, xfSize - 1, this);
  }

View Full Code Here

                          * Nick Burch said to use org.apache.poi.ss.usermodel.BuiltinFormats,
                          * and I see javadoc for that at apache.org, but it's not in the
                          * POI 3.5 Beta 5 jars.  Scheduled to appear in 3.5 beta 6.
                          */
                    int styleIndex = Integer.parseInt(cellStyleStr);
                    XSSFCellStyle style = stylesTable.getStyleAt(styleIndex);
                    this.formatIndex = style.getDataFormat();
                    this.formatString = style.getDataFormatString();
                    if (this.formatString == null)
                        this.formatString = BuiltinFormats.getBuiltinFormat(this.formatIndex);
                }
            }

View Full Code Here

0 1 2 3 4 5 6 7

TOP

Related Classes of org.apache.poi.xssf.usermodel.XSSFCellStyle

br.net.woodstock.rockframework.document.spreadsheet.poi.XSSFSpreadsheetDocumentWriter

br.net.woodstock.rockframework.office.spreadsheet.poi.XSSFSpreadsheetDocumentWriter

com.common.platform.excel.parser.XSSFParser

com.narirelays.ems.utils.excel.XSSFHtmlHelper

com.narirelays.ems.utils.excel.XSSFHtmlHelperV2

com.narirelays.ems.utils.ExcelUtility

org.apache.metamodel.excel.XlsxSheetToRowsHandler

org.apache.poi.ss.examples.html.XSSFHtmlHelper

org.apache.poi.xssf.eventusermodel.XLSX2CSV$MyXSSFSheetHandler

org.apache.poi.xssf.eventusermodel.XSSFSheetXMLHandler

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.