//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getRange("A1").getInterior().setPattern(Pattern.LightDown); worksheet.getRange("A1").getInterior().setColor(Color.GetPink()); worksheet.getRange("A1").getInterior().setPatternColorIndex(5); //save to an excel file workbook.save("PatternFill.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) worksheet.getRange("A1").interior.pattern = Pattern.LightDown worksheet.getRange("A1").interior.color = Color.GetPink() worksheet.getRange("A1").interior.patternColorIndex = 5 //save to an excel file workbook.save("PatternFill.xlsx")