// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getRange("A1").getInterior().setPattern(Pattern.RectangularGradient); ((IRectangularGradient) worksheet.getRange("A1").getInterior().getGradient()).getColorStops().get(0).setColor(Color.GetRed()); ((IRectangularGradient) worksheet.getRange("A1").getInterior().getGradient()).getColorStops().get(1).setColor(Color.GetGreen()); ((IRectangularGradient) worksheet.getRange("A1").getInterior().getGradient()).setBottom(0.2); ((IRectangularGradient) worksheet.getRange("A1").getInterior().getGradient()).setRight(0.3); ((IRectangularGradient) worksheet.getRange("A1").getInterior().getGradient()).setTop(0.4); ((IRectangularGradient) worksheet.getRange("A1").getInterior().getGradient()).setLeft(0.5); // Save to an excel file workbook.save("RectangularGradientFill.xlsx");
// Create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) worksheet.getRange("A1").interior.pattern = Pattern.RectangularGradient (worksheet.getRange("A1").interior.gradient as IRectangularGradient).colorStops.get(0).color = Color.GetRed() (worksheet.getRange("A1").interior.gradient as IRectangularGradient).colorStops.get(1).color = Color.GetGreen() (worksheet.getRange("A1").interior.gradient as IRectangularGradient).bottom = 0.2 (worksheet.getRange("A1").interior.gradient as IRectangularGradient).right = 0.3 (worksheet.getRange("A1").interior.gradient as IRectangularGradient).top = 0.4 (worksheet.getRange("A1").interior.gradient as IRectangularGradient).left = 0.5 // Save to an excel file workbook.save("RectangularGradientFill.xlsx")