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

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

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

org.openxmlformats.schemas.spreadsheetml.x2006.main.CTFill

    ctBorders.setBorderArray(ctb);
    styleSheet.setBorders(ctBorders);


    // Xfs
    if(xfs.size() > 0) {
      CTCellXfs ctXfs = CTCellXfs.Factory.newInstance();
      ctXfs.setCount(xfs.size());
      ctXfs.setXfArray(
          xfs.toArray(new CTXf[xfs.size()])
      );
      styleSheet.setCellXfs(ctXfs);
    }

View Full Code Here

    }


    private float getColumnWidthInPixels(int columnIndex){
        XSSFSheet sheet = (XSSFSheet)getDrawing().getParent();


        CTCol col = sheet.getColumnHelper().getColumn(columnIndex, false);
        double numChars = col == null || !col.isSetWidth() ? DEFAULT_COLUMN_WIDTH : col.getWidth();


        return (float)numChars*XSSFWorkbook.DEFAULT_CHARACTER_WIDTH;
    }

View Full Code Here

     *
     * @param columnIndex - the column to set (0-based)
     * @return width - the width in units of 1/256th of a character width
     */
    public int getColumnWidth(int columnIndex) {
        CTCol col = columnHelper.getColumn(columnIndex, false);
        double width = col == null || !col.isSetWidth() ? getDefaultColumnWidth() : col.getWidth();
        return (int)(width*256);
    }

View Full Code Here

    public void groupColumn(int fromColumn, int toColumn) {
        groupColumn1Based(fromColumn+1, toColumn+1);
    }
    private void groupColumn1Based(int fromColumn, int toColumn) {
        CTCols ctCols=worksheet.getColsArray(0);
        CTCol ctCol=CTCol.Factory.newInstance();
        ctCol.setMin(fromColumn);
        ctCol.setMax(toColumn);
        this.columnHelper.addCleanColIntoCols(ctCols, ctCol);
        for(int index=fromColumn;index<=toColumn;index++){
            CTCol col=columnHelper.getColumn1Based(index, false);
            //col must exist
            short outlineLevel=col.getOutlineLevel();
            col.setOutlineLevel((short)(outlineLevel+1));
            index=(int)col.getMax();
        }
        worksheet.setColsArray(0,ctCols);
        setSheetFormatPrOutlineLevelCol();
    }

View Full Code Here

     *
     * @param columnIndex - the column to set (0-based)
     * @return hidden - <code>false</code> if the column is visible
     */
    public boolean isColumnHidden(int columnIndex) {
        CTCol col = columnHelper.getColumn(columnIndex, false);
        return col != null && col.getHidden();
    }

View Full Code Here

        }
    }


    private void collapseColumn(int columnNumber) {
        CTCols cols = worksheet.getColsArray(0);
        CTCol col = columnHelper.getColumn(columnNumber, false);
        int colInfoIx = columnHelper.getIndexOfColumn(cols, col);
        if (colInfoIx == -1) {
            return;
        }
        // Find the start of the group.
        int groupStartColInfoIx = findStartOfColumnOutlineGroup(colInfoIx);


        CTCol columnInfo = cols.getColArray(groupStartColInfoIx);


        // Hide all the columns until the end of the group
        int lastColMax = setGroupHidden(groupStartColInfoIx, columnInfo
                .getOutlineLevel(), true);


        // write collapse field
        setColumn(lastColMax + 1, null, 0, null, null, Boolean.TRUE);

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

0 1 2 3 4 5 6 7 8 9

TOP

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

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.