// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); // Change to build in name style. worksheet.getRange("A1").setValue("Bad"); worksheet.getRange("A1").setStyle(workbook.getStyles().get("Bad")); // Change to custom name style. // Add custom name style. IStyle style = workbook.getStyles().add("testStyle"); // Config custom name style settings begin. // Border style.getBorders().get(BordersIndex.EdgeLeft).setLineStyle(BorderLineStyle.Thin); style.getBorders().get(BordersIndex.EdgeTop).setLineStyle(BorderLineStyle.Thick); style.getBorders().get(BordersIndex.EdgeRight).setLineStyle(BorderLineStyle.Double); style.getBorders().get(BordersIndex.EdgeBottom).setLineStyle(BorderLineStyle.Double); style.getBorders().setColor(Color.FromArgb(0, 255, 0)); // Font style.getFont().setThemeColor(ThemeColor.Accent1); style.getFont().setTintAndShade(0.8); style.getFont().setItalic(true); style.getFont().setBold(true); style.getFont().setName("LiSu"); style.getFont().setSize(28); style.getFont().setStrikethrough(true); style.getFont().setSubscript(true); style.getFont().setSuperscript(false); style.getFont().setUnderline(UnderlineType.Double); // Protection style.setFormulaHidden(true); style.setLocked(false); // Number style.setNumberFormat("#,##0_);[Red](#,##0)"); // Alignment style.setHorizontalAlignment(HorizontalAlignment.Right); style.setVerticalAlignment(VerticalAlignment.Bottom); style.setWrapText(true); style.setIndentLevel(5); style.setOrientation(45); // Fill style.getInterior().setColorIndex(5); style.getInterior().setPattern(Pattern.Down); style.getInterior().setPatternColor(Color.FromArgb(0, 0, 255)); style.setIncludeAlignment(false); style.setIncludeBorder(true); style.setIncludeFont(false); style.setIncludeNumber(true); style.setIncludePatterns(false); style.setIncludeProtection(true); // Config custom name style settings end. // Set range's style to custom name style. worksheet.getRange("A2").setValue("My test style"); worksheet.getRange("A2").setStyle(worksheet.getWorkbook().getStyles().get("testStyle")); worksheet.getRange("A2").setColumnWidth(20); // Save to an excel file workbook.save("ApplyStyle.xlsx");
// Create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) // Change to build in name style. worksheet.getRange("A1").value = "Bad" worksheet.getRange("A1").style = workbook.styles.get("Bad") // Change to custom name style. // Add custom name style. val style = workbook.styles.add("testStyle") // Config custom name style settings begin. // Border style.borders.get(BordersIndex.EdgeLeft).lineStyle = BorderLineStyle.Thin style.borders.get(BordersIndex.EdgeTop).lineStyle = BorderLineStyle.Thick style.borders.get(BordersIndex.EdgeRight).lineStyle = BorderLineStyle.Double style.borders.get(BordersIndex.EdgeBottom).lineStyle = BorderLineStyle.Double style.borders.color = Color.FromArgb(0, 255, 0) // Font style.font.themeColor = ThemeColor.Accent1 style.font.tintAndShade = 0.8 style.font.italic = true style.font.bold = true style.font.name = "LiSu" style.font.size = 28.0 style.font.strikethrough = true style.font.subscript = true style.font.superscript = false style.font.underline = UnderlineType.Double // Protection style.formulaHidden = true style.locked = false // Number style.numberFormat = "#,##0_);[Red](#,##0)" // Alignment style.horizontalAlignment = HorizontalAlignment.Right style.verticalAlignment = VerticalAlignment.Bottom style.wrapText = true style.indentLevel = 5 style.orientation = 45 // Fill style.interior.colorIndex = 5 style.interior.pattern = Pattern.Down style.interior.patternColor = Color.FromArgb(0, 0, 255) style.includeAlignment = false style.includeBorder = true style.includeFont = false style.includeNumber = true style.includePatterns = false style.includeProtection = true // Config custom name style settings end. // Set range's style to custom name style. worksheet.getRange("A2").value = "My test style" worksheet.getRange("A2").style = worksheet.workbook.styles.get("testStyle") worksheet.getRange("A2").columnWidth = 20.0 // Save to an excel file workbook.save("ApplyStyle.xlsx")