//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet worksheet = workbook.Worksheets[0]; worksheet.Range["A1"].Value = 100; worksheet.Range["C1"].Formula = "=$A$1"; worksheet.Range["E1:E5"].Formula = "=$A$1"; foreach (var item in worksheet.Range["A1"].GetDependents()) { item.Interior.Color = Color.Azure; } // Save to an excel file workbook.Save("Dependents.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim worksheet As IWorksheet = workbook.Worksheets(0) worksheet.Range!A1.Value = 100 worksheet.Range!C1.Formula = "=$A$1" worksheet.Range("E1:E5").Formula = "=$A$1" For Each item In worksheet.Range!A1.GetDependents() item.Interior.Color = Color.Azure Next ' save to an excel file workbook.Save("Dependents.xlsx")