Syncfusion.XlsIO.Base
Example 


GetDependents() Method

Gets the dependent cells which refer to other cells.
Syntax
'Declaration
 
Overloads Function GetDependents() As IRange()
'Usage
 
Dim instance As IRange
Dim value() As IRange
 
value = instance.GetDependents()
IRange[] GetDependents()

Return Value

Returns the dependent cells or null if value was not found.
Example
The following code illustrates how to get the dependent cells from the worksheet.
ExcelEngine excelEngine = new ExcelEngine();
IApplication application = excelEngine.Excel;
IWorkbook workbook = application.Workbooks.Create("FormulaExcel.xlsx");
IWorksheet sheet = workbook.Worksheets[0];
            
IRange[] results = sheet["A1"].GetDependents();
            
string fileName = "Dependents.xlsx";
workbook.SaveAs(fileName);
workbook.Close();
excelEngine.Dispose();
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also