//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.LightDown; worksheet.Range["A1"].Interior.Color = Color.Pink; worksheet.Range["A1"].Interior.PatternColorIndex = 5; // Save to an excel file workbook.Save("PatternFill.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim worksheet As IWorksheet = workbook.Worksheets(0) With worksheet.Range!A1.Interior .Pattern = Pattern.LightDown .Color = Color.Pink .PatternColorIndex = 5 End With ' save to an excel file workbook.Save("PatternFill.xlsx")