Package org.apache.poi.xssf.usermodel

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

92
93
94
95
96
97
98
            // Color is a tint of white or black
            rgb = ctColor.getSysClr().getLastClr();
        } else {
            return null;
        }
        return new XSSFColor(rgb);       
    }
View Full Code Here
111
112
113
114
115
116
117
118
119
120
121
122
          // No theme set, nothing to do
          return;
       }

       // Get the theme colour
       XSSFColor themeColor = getThemeColor(color.getTheme());
       // Set the raw colour, not the adjusted one
       // Do a raw set, no adjusting at the XSSFColor layer either
       color.getCTColor().setRgb(themeColor.getCTColor().getRgb());

       // All done
    }
View Full Code Here
70
71
72
73
74
75
76
77
78
79
80
81
82
    public void testColorFromTheme() {
        XSSFWorkbook wb = XSSFTestDataSamples.openSampleWorkbook("styles.xlsx");
        XSSFCell cellWithThemeColor = wb.getSheetAt(0).getRow(10).getCell(0);
        //color RGB will be extracted from theme
        XSSFColor foregroundColor = cellWithThemeColor.getCellStyle().getFillForegroundXSSFColor();
        byte[] rgb = foregroundColor.getRgb();
        byte[] rgbWithTint = foregroundColor.getRgbWithTint();
        // Dk2
        assertEquals(rgb[0],31);
        assertEquals(rgb[1],73);
        assertEquals(rgb[2],125);
        // Dk2, lighter 40% (tint is about 0.39998)
View Full Code Here
321
322
323
324
325
326
327
328
        return CellStyle.VERTICAL_TOP;
    }
  }

  private short getColor(final Color color) {
    XSSFColor c = new XSSFColor(new java.awt.Color(color.getRed(), color.getGreen(), color.getBlue()));
    return c.getIndexed();
  }
View Full Code Here
326
327
328
329
330
331
332
333
    XSSFColor c = new XSSFColor(new java.awt.Color(color.getRed(), color.getGreen(), color.getBlue()));
    return c.getIndexed();
  }

  private short getBackgroundColor(final Color color) {
    XSSFColor c = new XSSFColor(new java.awt.Color(color.getRed(), color.getGreen(), color.getBlue()));
    return c.getIndexed();
  }
View Full Code Here
306
307
308
309
310
311
312
313
        return CellStyle.VERTICAL_TOP;
    }
  }

  private short getColor(final Color color) {
    XSSFColor c = new XSSFColor(new java.awt.Color(color.getRed(), color.getGreen(), color.getBlue()));
    return c.getIndexed();
  }
View Full Code Here
311
312
313
314
315
316
317
318
    XSSFColor c = new XSSFColor(new java.awt.Color(color.getRed(), color.getGreen(), color.getBlue()));
    return c.getIndexed();
  }

  private short getBackgroundColor(final Color color) {
    XSSFColor c = new XSSFColor(new java.awt.Color(color.getRed(), color.getGreen(), color.getBlue()));
    return c.getIndexed();
  }
View Full Code Here
TOP

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

  • br.net.woodstock.rockframework.document.spreadsheet.poi.XSSFSpreadsheetDocumentWriter
  • br.net.woodstock.rockframework.office.spreadsheet.poi.XSSFSpreadsheetDocumentWriter
  • com.narirelays.ems.utils.ExcelUtility
  • org.apache.metamodel.excel.ExcelUtils
  • org.apache.metamodel.excel.XlsxSheetToRowsHandler
  • org.apache.poi.hssf.util.HSSFColor
  • org.apache.poi.xssf.model.TestThemesTable
  • org.apache.poi.xssf.model.ThemesTable
  • org.apache.poi.xssf.usermodel.extensions.TestXSSFCellFill
  • org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.