List of usage examples for org.apache.poi.hssf.util HSSFColor getHexString
public String getHexString()
From source file:br.com.tecsinapse.dataio.style.CssStyle.java
License:LGPL
public static String toBackgroundColor(HSSFColor hssfColor, boolean whiteAsTransparent) { if (hssfColor == null) { return ""; }/*from w w w . j a v a 2 s . c om*/ if (whiteAsTransparent && WHITE.getHexString().equals(hssfColor.getHexString())) { return ""; } return String.format("background-color:%s;", StyleColorUtil.toHexColor(hssfColor)); }
From source file:com.eryansky.core.excelTools.ExcelUtils.java
License:Apache License
private static boolean isSameColor(int a, int b, HSSFPalette apalette, HSSFPalette bpalette) { if (a == b)/* w ww . j a v a 2 s. co m*/ return true; HSSFColor acolor = apalette.getColor(a); HSSFColor bcolor = bpalette.getColor(b); if (acolor == null) return true; if (bcolor == null) return false; return acolor.getHexString().equals(bcolor.getHexString()); }
From source file:Importers.ExcelImporter.java
License:Apache License
@Override public DefaultMutableTreeNode readFile(File file) { System.out.println("==ExcelImporter=readFile: " + file.getAbsolutePath()); DefaultMutableTreeNode root = new DefaultMutableTreeNode("vulns"); try {// www. j a va 2s .c o m POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(file)); HSSFWorkbook wb = new HSSFWorkbook(fs); HSSFSheet sheet = wb.getSheetAt(0); HSSFRow row; HSSFCell cell; int rows; // No of rows rows = sheet.getPhysicalNumberOfRows(); int cols = 0; // No of columns int tmp = 0; // This trick ensures that we get the data properly even if it doesn't start from first few rows for (int i = 0; i < 10 || i < rows; i++) { row = sheet.getRow(i); if (row != null) { tmp = sheet.getRow(i).getPhysicalNumberOfCells(); if (tmp > cols) { cols = tmp; } } } for (int r = 1; r < rows; r++) { row = sheet.getRow(r); if (row != null) { // Create a new vuln Vulnerability vuln = new Vulnerability(); vuln.setTitle("NEW"); vuln.setIs_custom_risk(true); vuln.setRisk_category("None"); for (int c = 0; c < cols; c++) { cell = row.getCell(c); if (cell != null) { // Your code here String value = cell.getStringCellValue(); switch (c) { case 1:// title vuln.setTitle(value); break; case 2: // Risk CellStyle style = cell.getCellStyle(); short colorIdx = style.getFillForegroundColor(); HSSFPalette palette = ((HSSFWorkbook) wb).getCustomPalette(); HSSFColor color = palette.getColor(colorIdx); String cc = color.getHexString(); System.out.println(cc); if (cc.equalsIgnoreCase("8080:8080:0")) { vuln.setRisk_category("Critical"); } else if (cc.equalsIgnoreCase("FFFF:0:0")) { vuln.setRisk_category("High"); } else if (cc.equalsIgnoreCase("FFFF:6666:0")) { vuln.setRisk_category("Medium"); } else if (cc.equalsIgnoreCase("F2F2:ECEC:0")) { vuln.setRisk_category("Low"); } else if (cc.equalsIgnoreCase("0:0:FFFF")) { vuln.setRisk_category("Info"); } break; case 3:// cvss string System.out.println(value); if (value.equalsIgnoreCase("No CVSS Vector")) { vuln.setIs_custom_risk(true); } else { vuln.setIs_custom_risk(false); vuln.setCvss_vector_string("CVSS2#" + value); } break; case 4://Description vuln.setDescription(value); break; case 5://Recommendation vuln.setRecommendation(value); break; case 6://Affected Hosts try { String[] lines = value.split("\n"); for (String line : lines) { String[] bits = line.split(" "); Host host = new Host(); host.setIp_address(bits[0]); String portprotocol = bits[2]; host.setPortnumber(portprotocol.split("/")[0]); host.setProtocol(portprotocol.split("/")[1]); vuln.addAffectedHost(host); } } catch (Exception ex) { ; } break; } } } System.out.println(vuln); root.add(new DefaultMutableTreeNode(vuln)); } } } catch (Exception ex) { ex.printStackTrace(); } return root; }
From source file:org.bbreak.excella.core.test.util.TestUtil.java
License:Open Source License
private static String getHSSFColorString(HSSFWorkbook workbook, short index) { HSSFPalette palette = workbook.getCustomPalette(); if (palette.getColor(index) != null) { HSSFColor color = palette.getColor(index); return color.getHexString(); } else {//from ww w . j ava 2 s . c o m return ""; } }
From source file:org.bbreak.excella.reports.ReportsTestUtil.java
License:Open Source License
/** * HSSF????// w w w .j ava 2 s. c o m * * @param workbook * @param index * @return HSSF?? */ private static String getHSSFColorString(HSSFWorkbook workbook, short index) { HSSFPalette palette = workbook.getCustomPalette(); if (palette.getColor(index) != null) { HSSFColor color = palette.getColor(index); return color.getHexString(); } else { return ""; } }
From source file:org.drugepi.table.ExcelUtils.java
License:Mozilla Public License
private static boolean cellIsColor(Cell cell, ColorRepresentation color) { if (cell == null) return false; CellStyle style = cell.getCellStyle(); Color bgColor = style.getFillForegroundColorColor(); if (bgColor instanceof XSSFColor) { XSSFColor xssfBgColor = (XSSFColor) bgColor; // System.out.printf("Cell color is %s index is %d %d\n", xssfBgColor.getARGBHex(), xssfBgColor.getRgb()[0], xssfBgColor.getIndexed()); return xssfBgColor.getARGBHex().equalsIgnoreCase(color.xssfArgb); } else if (bgColor instanceof HSSFColor) { HSSFColor hssfBgColor = (HSSFColor) bgColor; // System.out.printf("Cell color is %s\n", hssfBgColor.getHexString()); return hssfBgColor.getHexString().equalsIgnoreCase(color.hssfHexString); } else//www .ja v a 2 s. c o m return false; }
From source file:org.pentaho.reporting.engine.classic.core.bugs.Prd3899IT.java
License:Open Source License
public void testBug() throws ResourceException, IOException, ReportProcessingException { final MasterReport report = DebugReportRunner.parseGoldenSampleReport("Prd-3889.prpt"); final ByteArrayOutputStream bout = new ByteArrayOutputStream(); ExcelReportUtil.createXLS(report, bout); final HSSFWorkbook wb = new HSSFWorkbook(new ByteArrayInputStream(bout.toByteArray())); final HSSFSheet sheetAt = wb.getSheetAt(0); final HSSFRow row = sheetAt.getRow(0); final HSSFCell cell0 = row.getCell(0); // assert that we are in the correct export type .. final HSSFCellStyle cellStyle = cell0.getCellStyle(); final HSSFColor fillBackgroundColorColor = cellStyle.getFillBackgroundColorColor(); final HSSFColor fillForegroundColorColor = cellStyle.getFillForegroundColorColor(); assertEquals("0:0:0", fillBackgroundColorColor.getHexString()); assertEquals("FFFF:FFFF:9999", fillForegroundColorColor.getHexString()); // assert that there are no extra columns .. final HSSFRow row8 = sheetAt.getRow(7); assertNull(row8);/* w w w. j a v a 2 s.c om*/ }
From source file:org.pentaho.reporting.engine.classic.core.bugs.Prd5391.java
License:Open Source License
@Test public void testSlowExport() throws ResourceException, ReportProcessingException, IOException { // This establishes a baseline for the second test using the slow export. final MasterReport report = DebugReportRunner.parseLocalReport("Prd-5391.prpt", Prd5391.class); final ByteArrayOutputStream bout = new ByteArrayOutputStream(); ExcelReportUtil.createXLS(report, bout); final HSSFWorkbook wb = new HSSFWorkbook(new ByteArrayInputStream(bout.toByteArray())); final HSSFSheet sheetAt = wb.getSheetAt(0); final HSSFRow row = sheetAt.getRow(0); final HSSFCell cell0 = row.getCell(0); // assert that we are in the correct export type .. final HSSFCellStyle cellStyle = cell0.getCellStyle(); final HSSFColor fillBackgroundColorColor = cellStyle.getFillBackgroundColorColor(); final HSSFColor fillForegroundColorColor = cellStyle.getFillForegroundColorColor(); Assert.assertEquals("0:0:0", fillBackgroundColorColor.getHexString()); Assert.assertEquals("FFFF:8080:8080", fillForegroundColorColor.getHexString()); HSSFFont font = cellStyle.getFont(wb); Assert.assertEquals("Times New Roman", font.getFontName()); }
From source file:org.pentaho.reporting.engine.classic.core.bugs.Prd5391.java
License:Open Source License
@Test public void testFastExport() throws ResourceException, ReportProcessingException, IOException { // This establishes a baseline for the second test using the slow export. final MasterReport report = DebugReportRunner.parseLocalReport("Prd-5391.prpt", Prd5391.class); final ByteArrayOutputStream bout = new ByteArrayOutputStream(); FastExcelReportUtil.processXls(report, bout); final HSSFWorkbook wb = new HSSFWorkbook(new ByteArrayInputStream(bout.toByteArray())); final HSSFSheet sheetAt = wb.getSheetAt(0); final HSSFRow row = sheetAt.getRow(0); final HSSFCell cell0 = row.getCell(0); // assert that we are in the correct export type .. final HSSFCellStyle cellStyle = cell0.getCellStyle(); final HSSFColor fillBackgroundColorColor = cellStyle.getFillBackgroundColorColor(); final HSSFColor fillForegroundColorColor = cellStyle.getFillForegroundColorColor(); Assert.assertEquals("0:0:0", fillBackgroundColorColor.getHexString()); Assert.assertEquals("FFFF:8080:8080", fillForegroundColorColor.getHexString()); HSSFFont font = cellStyle.getFont(wb); Assert.assertEquals("Times New Roman", font.getFontName()); }
From source file:org.pentaho.reporting.engine.classic.core.bugs.Prd5391IT.java
License:Open Source License
@Test public void testSlowExport() throws ResourceException, ReportProcessingException, IOException { // This establishes a baseline for the second test using the slow export. final MasterReport report = DebugReportRunner.parseLocalReport("Prd-5391.prpt", Prd5391IT.class); final ByteArrayOutputStream bout = new ByteArrayOutputStream(); ExcelReportUtil.createXLS(report, bout); final HSSFWorkbook wb = new HSSFWorkbook(new ByteArrayInputStream(bout.toByteArray())); final HSSFSheet sheetAt = wb.getSheetAt(0); final HSSFRow row = sheetAt.getRow(0); final HSSFCell cell0 = row.getCell(0); // assert that we are in the correct export type .. final HSSFCellStyle cellStyle = cell0.getCellStyle(); final HSSFColor fillBackgroundColorColor = cellStyle.getFillBackgroundColorColor(); final HSSFColor fillForegroundColorColor = cellStyle.getFillForegroundColorColor(); Assert.assertEquals("0:0:0", fillBackgroundColorColor.getHexString()); Assert.assertEquals("FFFF:8080:8080", fillForegroundColorColor.getHexString()); HSSFFont font = cellStyle.getFont(wb); Assert.assertEquals("Times New Roman", font.getFontName()); }