Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDefinedNames

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

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDefinedNames

org.openxmlformats.schemas.spreadsheetml.x2006.main.CTFills
3.org/2001/XMLSchema}anyType"> <sequence> <element name="definedName" type="{http://schemas.microsoft.com/office/excel/2008/2/main}CT_DefinedName" maxOccurs="unbounded"/> </sequence> </restriction> </complexContent> </complexType>

     * @throws POIXMLException if such a name already exists in the workbook
     */
    private XSSFName createBuiltInName(String builtInName, int sheetNumber) {
        validateSheetIndex(sheetNumber);


        CTDefinedNames names = workbook.getDefinedNames() == null ? workbook.addNewDefinedNames() : workbook.getDefinedNames();
        CTDefinedName nameRecord = names.addNewDefinedName();
        nameRecord.setName(builtInName);
        nameRecord.setLocalSheetId(sheetNumber);


        XSSFName name = new XSSFName(nameRecord, this);
        for (XSSFName nr : namedRanges) {

View Full Code Here

     * marshal named ranges from the {@link #namedRanges} collection to the underlying CTWorkbook bean
     */
    private void saveNamedRanges(){
        // Named ranges
        if(namedRanges.size() > 0) {
            CTDefinedNames names = CTDefinedNames.Factory.newInstance();
            CTDefinedName[] nr = new CTDefinedName[namedRanges.size()];
            int i = 0;
            for(XSSFName name : namedRanges) {
                nr[i] = name.getCTName();
                i++;
            }
            names.setDefinedNameArray(nr);
            workbook.setDefinedNames(names);
        } else {
            if(workbook.isSetDefinedNames()) {
                workbook.unsetDefinedNames();
            }

View Full Code Here

            if(cellXfs != null) xfs.addAll(Arrays.asList(cellXfs.getXfArray()));


            CTCellStyleXfs cellStyleXfs = styleSheet.getCellStyleXfs();
            if(cellStyleXfs != null) styleXfs.addAll(Arrays.asList(cellStyleXfs.getXfArray()));


            CTDxfs styleDxfs = styleSheet.getDxfs();
      if(styleDxfs != null) dxfs.addAll(Arrays.asList(styleDxfs.getDxfArray()));


    } catch (XmlException e) {
      throw new IOException(e.getLocalizedMessage());
    }
  }

View Full Code Here

      styleSheet.setCellStyleXfs(ctSXfs);
    }


    // Style dxfs
    if(dxfs.size() > 0) {
      CTDxfs ctDxfs = CTDxfs.Factory.newInstance();
      ctDxfs.setCount(dxfs.size());
      ctDxfs.setDxfArray(dxfs.toArray(new CTDxf[dxfs.size()])
      );
      styleSheet.setDxfs(ctDxfs);
    }


    // Save

View Full Code Here

     * for the color to be shown in the cell.
     *
     * @param color - the color to use
     */
    public void setFillBackgroundColor(XSSFColor color) {
        CTFill ct = getCTFill();
        CTPatternFill ptrn = ct.getPatternFill();
        if(color == null) {
            if(ptrn != null) ptrn.unsetBgColor();
        } else {
            if(ptrn == null) ptrn = ct.addNewPatternFill();
            ptrn.setBgColor(color.getCTColor());
        }


        int idx = _stylesSource.putFill(new XSSFCellFill(ct));

View Full Code Here

    * <i>Note: Ensure Foreground color is set prior to background color.</i>
    * @param color the color to use
    * @see #setFillBackgroundColor(org.apache.poi.xssf.usermodel.XSSFColor) )
    */
    public void setFillForegroundColor(XSSFColor color) {
        CTFill ct = getCTFill();


        CTPatternFill ptrn = ct.getPatternFill();
        if(color == null) {
            if(ptrn != null) ptrn.unsetFgColor();
        } else {
            if(ptrn == null) ptrn = ct.addNewPatternFill();
            ptrn.setFgColor(color.getCTColor());
        }


        int idx = _stylesSource.putFill(new XSSFCellFill(ct));

View Full Code Here


    /**
     * Get a <b>copy</b> of the currently used CTFill, if none is used, return a new instance.
     */
    private CTFill getCTFill(){
        CTFill ct;
        if(_cellXf.getApplyFill()) {
            int fillIndex = (int)_cellXf.getFillId();
            XSSFCellFill cf = _stylesSource.getFillAt(fillIndex);


            ct = (CTFill)cf.getCTFill().copy();

View Full Code Here

     * @see #setFillBackgroundColor(short)
     * @see #setFillForegroundColor(short)
     * @param fp  fill pattern (set to {@link org.apache.poi.ss.usermodel.CellStyle#SOLID_FOREGROUND} to fill w/foreground color)
     */
   public void setFillPattern(short fp) {
        CTFill ct = getCTFill();
        CTPatternFill ptrn = ct.isSetPatternFill() ? ct.getPatternFill() : ct.addNewPatternFill();
        if(fp == NO_FILL && ptrn.isSetPatternType()) ptrn.unsetPatternType();
        else ptrn.setPatternType(STPatternType.Enum.forInt(fp + 1));


        int idx = _stylesSource.putFill(new XSSFCellFill(ct));

View Full Code Here

          XSSFFont f = new XSSFFont(font, idx);
          fonts.add(f);
          idx++;
        }
      }
            CTFills ctfills = styleSheet.getFills();
            if(ctfills != null){
                for (CTFill fill : ctfills.getFillArray()) {
                    fills.add(new XSSFCellFill(fill));
                }
            }


            CTBorders ctborders = styleSheet.getBorders();

View Full Code Here

    for(XSSFFont f : fonts) ctfnt[idx++] = f.getCTFont();
    ctFonts.setFontArray(ctfnt);
    styleSheet.setFonts(ctFonts);


    // Fills
    CTFills ctFills = CTFills.Factory.newInstance();
    ctFills.setCount(fills.size());
    CTFill[] ctf = new CTFill[fills.size()];
    idx = 0;
    for(XSSFCellFill f : fills) ctf[idx++] = f.getCTFill();
    ctFills.setFillArray(ctf);
    styleSheet.setFills(ctFills);


    // Borders
    CTBorders ctBorders = CTBorders.Factory.newInstance();
    ctBorders.setCount(borders.size());

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDefinedNames

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.