Unlock 30% off on Manual Testing Annual Plans this Holiday Season.

Copied to Clipboard!

How to use createCustomStyle method of com.paypal.selion.internal.reports.excelreport.Styles class

Best SeLion code snippet using com.paypal.selion.internal.reports.excelreport.Styles.createCustomStyle

Source:Styles.java

...28            thinBorderStyle, styleBorderThinCenter, styleBorderThinLeftTop, hyperLinkStyle;29    private Styles() {30        // Utility class. So hide the constructor31    }32    private static HSSFCellStyle createCustomStyle(HSSFFont fontStyle, Short... alignment) {33        HSSFCellStyle style = wb1.createCellStyle();34        style.setFont(fontStyle);35        if (alignment.length > 0) {36            style.setAlignment(alignment[0]);37        }38        return style;39    }40    private static HSSFFont createCustomFont(short colorIndex, Byte underlineWeight) {41        HSSFFont font = wb1.createFont();42        font.setFontName(HSSFFont.FONT_ARIAL);43        font.setFontHeightInPoints((short) 10);44        font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);45        font.setColor(colorIndex);46        font.setUnderline(underlineWeight);47        return font;48    }49    private static HSSFCellStyle setAllBorders(short borderWeight, HSSFCellStyle existingStyle) {50        existingStyle.setBorderBottom(borderWeight);51        existingStyle.setBorderTop(borderWeight);52        existingStyle.setBorderLeft(borderWeight);53        existingStyle.setBorderRight(borderWeight);54        return existingStyle;55    }56    public static void initStyles(HSSFWorkbook wb) {57        wb1 = wb;58        setHeadingStyle(createCustomStyle(createCustomFont(HSSFColor.LEMON_CHIFFON.index, HSSFFont.U_NONE),59                HSSFCellStyle.ALIGN_CENTER));60        getHeadingStyle().setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);61        getHeadingStyle().setFillForegroundColor(new HSSFColor.BLUE_GREY().getIndex());62        setHeadingStyle(setAllBorders(HSSFCellStyle.BORDER_DOUBLE, getHeadingStyle()));63        subHeading1Style = createCustomStyle(createCustomFont(HSSFColor.LIGHT_BLUE.index, HSSFFont.U_NONE));64        subHeading1Style = setAllBorders(HSSFCellStyle.BORDER_THIN, subHeading1Style);65        setSubHeading2Style(createCustomStyle(createCustomFont(HSSFColor.BROWN.index, HSSFFont.U_NONE),66                HSSFCellStyle.ALIGN_CENTER));67        setSubHeading2Style(setAllBorders(HSSFCellStyle.BORDER_MEDIUM, getSubHeading2Style()));68        setSubHeading2StyleThinBorder(createCustomStyle(createCustomFont(HSSFColor.BROWN.index, HSSFFont.U_NONE),69                HSSFCellStyle.ALIGN_LEFT));70        setSubHeading2StyleThinBorder(setAllBorders(HSSFCellStyle.BORDER_THIN, getSubHeading2StyleThinBorder()));71        setThinBorderStyle(wb.createCellStyle());72        setThinBorderStyle(setAllBorders(HSSFCellStyle.BORDER_THIN, getThinBorderStyle()));73        setStyleBorderThinCenter(wb.createCellStyle());74        setStyleBorderThinCenter(setAllBorders(HSSFCellStyle.BORDER_THIN, getStyleBorderThinCenter()));75        getStyleBorderThinCenter().setAlignment(HSSFCellStyle.ALIGN_CENTER);76        setStyleBorderThinLeftTop(wb.createCellStyle());77        setStyleBorderThinLeftTop(setAllBorders(HSSFCellStyle.BORDER_THIN, getStyleBorderThinLeftTop()));78        getStyleBorderThinLeftTop().setAlignment(HSSFCellStyle.ALIGN_LEFT);79        getStyleBorderThinLeftTop().setVerticalAlignment(HSSFCellStyle.VERTICAL_TOP);80        setHyperLinkStyle(wb.createCellStyle());81        setHyperLinkStyle(setAllBorders(HSSFCellStyle.BORDER_THIN, getHyperLinkStyle()));82        HSSFFont hyperLinkFont = createCustomFont(HSSFColor.BLUE.index, HSSFFont.U_SINGLE);...

createCustomStyle

Using AI Code Generation

1Workbook workbook = new XSSFWorkbook();2CellStyle style = Styles.createCustomStyle(workbook, IndexedColors.RED.getIndex(), (short) 10, (short) 100, IndexedColors.YELLOW.getIndex(), CellStyle.SOLID_FOREGROUND, CellStyle.ALIGN_CENTER, CellStyle.BORDER_THIN, CellStyle.BORDER_THIN, CellStyle.BORDER_THIN, CellStyle.BORDER_THIN, IndexedColors.BLACK.getIndex());3Cell cell = workbook.createSheet().createRow(0).createCell(0);4cell.setCellStyle(style);5String fileName = "customStyle.xlsx";6FileOutputStream fileOut = new FileOutputStream(fileName);7workbook.write(fileOut);8fileOut.close();9workbook.close();10File file = new File(fileName);11assertTrue(file.exists());12file.delete();13assertFalse(file.exists());14}15}16public class StylesTest {17public void testCreateCustomStyle() throws IOException {

createCustomStyle

Using AI Code Generation

1Styles.createCustomStyle(ExcelReportTest.class, "customStyle", "testStyle", Styles.STYLE_TYPE.HEADER);2Styles.getCustomStyle("customStyle");3Styles.getCustomStyle("customStyle", "testStyle");4Styles.getCustomStyle("customStyle", "testStyle", Styles.STYLE_TYPE.HEADER);5Styles.createCustomStyle(ExcelReportTest.class, "customStyle", "testStyle", Styles.STYLE_TYPE.HEADER);6Styles.getCustomStyle("customStyle");7Styles.getCustomStyle("customStyle", "testStyle");8Styles.getCustomStyle("customStyle", "testStyle", Styles.STYLE_TYPE.HEADER);

createCustomStyle

Using AI Code Generation

1Styles customStyle = Styles.createCustomStyle();2customStyle.setFontColor(IndexedColors.RED.getIndex());3customStyle.setFontSize((short) 10);4customStyle.setFontName("Times New Roman");5customStyle.setFontWeight(Font.BOLDWEIGHT_BOLD);6customStyle.setFontStyle(Font.BOLDITALIC);7customStyle.setBackgroundColor(IndexedColors.YELLOW.getIndex());8customStyle.setBorderColor(IndexedColors.GREEN.getIndex());9customStyle.setBorderStyle(CellStyle.BORDER_DOUBLE);10customStyle.setBorderWidth((short) 5);11customStyle.setDataFormat("#,##0.0");12customStyle.setHorizontalAlign(CellStyle.ALIGN_CENTER);13customStyle.setVerticalAlign(CellStyle.VERTICAL_CENTER);14customStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);15customStyle.setWrapText(true);16customStyle.setCellStyle(cell);17Styles customStyle = Styles.createCustomStyle();18customStyle.setFontColor(IndexedColors.RED);19customStyle.setFontSize((short) 10);20customStyle.setFontName("Times New Roman");21customStyle.setFontWeight(Font.BOLDWEIGHT_BOLD);22customStyle.setFontStyle(Font.BOLDITALIC);23customStyle.setBackgroundColor(IndexedColors.YELLOW);24customStyle.setBorderColor(IndexedColors.GREEN);25customStyle.setBorderStyle(CellStyle.BORDER_DOUBLE);

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.