//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet worksheet = workbook.Worksheets[0]; worksheet.Range["A1"].Interior.Pattern = GrapeCity.Documents.Excel.Pattern.LinearGradient; (worksheet.Range["A1"].Interior.Gradient as ILinearGradient).ColorStops[0].Color = Color.Red; (worksheet.Range["A1"].Interior.Gradient as ILinearGradient).ColorStops[1].Color = Color.Yellow; (worksheet.Range["A1"].Interior.Gradient as ILinearGradient).Degree = 90; // Save to an excel file workbook.Save("LinearGradientFill.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim worksheet As IWorksheet = workbook.Worksheets(0) worksheet.Range!A1.Interior.Pattern = Pattern.LinearGradient With TryCast(worksheet.Range!A1.Interior.Gradient, ILinearGradient) .ColorStops(0).Color = Color.Red .ColorStops(1).Color = Color.Yellow .Degree = 90 End With ' save to an excel file workbook.Save("LinearGradientFill.xlsx")