//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet worksheet = workbook.Worksheets[0]; worksheet.Range["E2"].Formula = "=sum(A1:A2, B4,C1:C3)"; worksheet.Range["A1"].Value = 1; worksheet.Range["A2"].Value = 2; worksheet.Range["B4"].Value = 3; worksheet.Range["C1"].Value = 4; worksheet.Range["C2"].Value = 5; worksheet.Range["C3"].Value = 6; foreach (var item in worksheet.Range["E2"].GetPrecedents()) { item.Interior.Color = Color.Pink; } // Save to an excel file workbook.Save("Precedents.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim worksheet As IWorksheet = workbook.Worksheets(0) With worksheet.Range !E2.Formula = "=sum(A1:A2, B4,C1:C3)" !A1.Value = 1 !A2.Value = 2 !B4.Value = 3 !C1.Value = 4 !C2.Value = 5 !C3.Value = 6 End With For Each item In worksheet.Range!E2.GetPrecedents() item.Interior.Color = Color.Pink Next ' save to an excel file workbook.Save("Precedents.xlsx")