Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.STDataValidationOperator.Enum

Package org.openxmlformats.schemas.spreadsheetml.x2006.main.STDataValidationOperator

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.STDataValidationOperator.Enum

org.openxmlformats.schemas.spreadsheetml.x2006.main.STUnsignedShortHex

    public XSSFTable createTable() {
       if(! worksheet.isSetTableParts()) {
          worksheet.addNewTableParts();
       }
       
       CTTableParts tblParts = worksheet.getTableParts();
       CTTablePart tbl = tblParts.addNewTablePart();
       
       // Table numbers need to be unique in the file, not just
       //  unique within the sheet. Find the next one
       int tableNumber = getPackagePart().getPackage().getPartsByContentType(XSSFRelation.TABLE.getContentType()).size() + 1;
       XSSFTable table = (XSSFTable)createRelationship(XSSFRelation.TABLE, XSSFFactory.getInstance(), tableNumber);

View Full Code Here

     * Create a new CTWorksheet instance with all values set to defaults
     *
     * @return a new instance
     */
    private static CTWorksheet newSheet(){
        CTWorksheet worksheet = CTWorksheet.Factory.newInstance();
        CTSheetFormatPr ctFormat = worksheet.addNewSheetFormatPr();
        ctFormat.setDefaultRowHeight(15.0);


        CTSheetView ctView = worksheet.addNewSheetViews().addNewSheetView();
        ctView.setWorkbookViewId(0);


        worksheet.addNewDimension().setRef("A1");


        worksheet.addNewSheetData();


        CTPageMargins ctMargins = worksheet.addNewPageMargins();
        ctMargins.setBottom(0.75);
        ctMargins.setFooter(0.3);
        ctMargins.setHeader(0.3);
        ctMargins.setLeft(0.7);
        ctMargins.setRight(0.7);

View Full Code Here

    }


    return new XSSFCellStyle(idx, styleXfId, this, theme);
  }
  public int putStyle(XSSFCellStyle style) {
    CTXf mainXF = style.getCoreXf();


    if(! xfs.contains(mainXF)) {
      xfs.add(mainXF);
    }
    return xfs.indexOf(mainXF);

View Full Code Here

    fills.add(new XSSFCellFill(ctFill[1]));


    CTBorder ctBorder = createDefaultBorder();
    borders.add(new XSSFCellBorder(ctBorder));


    CTXf styleXf = createDefaultXf();
    styleXfs.add(styleXf);
    CTXf xf = createDefaultXf();
    xf.setXfId(0);
    xfs.add(xf);
  }

View Full Code Here

    xf.setXfId(0);
    xfs.add(xf);
  }


  private static CTXf createDefaultXf() {
    CTXf ctXf = CTXf.Factory.newInstance();
    ctXf.setNumFmtId(0);
    ctXf.setFontId(0);
    ctXf.setFillId(0);
    ctXf.setBorderId(0);
    return ctXf;
  }

View Full Code Here

    this.dxfs.add(dxf);
    return this.dxfs.size();
  }


  public XSSFCellStyle createCellStyle() {
    CTXf xf = CTXf.Factory.newInstance();
    xf.setNumFmtId(0);
    xf.setFontId(0);
    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

     * the references to fills and borders remain.
     *
     * @return a copy of this style
     */
    public Object clone(){
        CTXf xf = (CTXf)_cellXf.copy();


        int xfSize = _stylesSource._getStyleXfsSize();
        int indexXf = _stylesSource.putCellXf(xf);
        return new XSSFCellStyle(indexXf-1, xfSize-1, _stylesSource, _theme);
    }

View Full Code Here

  
    private XSSFDataValidationConstraint getConstraint(CTDataValidation ctDataValidation) {
      XSSFDataValidationConstraint constraint = null;
      String formula1 = ctDataValidation.getFormula1();
      String formula2 = ctDataValidation.getFormula2();
      Enum operator = ctDataValidation.getOperator();
      org.openxmlformats.schemas.spreadsheetml.x2006.main.STDataValidationType.Enum type = ctDataValidation.getType();
    Integer validationType = XSSFDataValidation.validationTypeReverseMappings.get(type);
    Integer operatorType = XSSFDataValidation.operatorTypeReverseMappings.get(operator);
    constraint = new XSSFDataValidationConstraint(validationType,operatorType, formula1,formula2);
      return constraint;

View Full Code Here

  }
  
  public String prettyPrint() {
    StringBuilder builder = new StringBuilder();
    STDataValidationType.Enum vt = XSSFDataValidation.validationTypeMappings.get(validationType);
    Enum ot = XSSFDataValidation.operatorTypeMappings.get(operator);
    builder.append(vt);
    builder.append(' ');
    if (validationType!=ValidationType.ANY) {
      if (validationType != ValidationType.LIST && validationType != ValidationType.ANY && validationType != ValidationType.FORMULA) {
        builder.append(",").append(ot).append(", ");

View Full Code Here

   *  
   * @param password the password string you wish convert to an {@link STUnsignedShortHex}
   * @return {@link STUnsignedShortHex} that contains Excel hashed password in Hex format
   */
  private STUnsignedShortHex stringToExcelPassword(String password) {
    STUnsignedShortHex hexPassword = STUnsignedShortHex.Factory.newInstance();
    hexPassword.setStringValue(String.valueOf(HexDump.shortToHex(PasswordRecord.hashPassword(password))).substring(2));
    return hexPassword;
  }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.openxmlformats.schemas.spreadsheetml.x2006.main.STDataValidationOperator.Enum

com.narirelays.ems.utils.ExcelUtility

org.apache.poi.hssf.extractor.HXFExcelExtractor

org.apache.poi.hssf.HSSFXML

org.apache.poi.hssf.model.SharedStringsTable

org.apache.poi.xssf.eventusermodel.TestReadOnlySharedStringsTable

org.apache.poi.xssf.eventusermodel.XSSFReader$SheetIterator

org.apache.poi.xssf.model.CommentsTable

org.apache.poi.xssf.model.Control

org.apache.poi.xssf.model.Drawing

org.apache.poi.xssf.model.ExternalLinksTable

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.