How to get the intersection of two ranges in Excel worksheet using C#, VB.NET

using Syncfusion.XlsIO;

Imports Syncfusion.XlsIO

using (ExcelEngine excelEngine = new ExcelEngine())
{
    //Instantiate the application object
    IApplication application = excelEngine.Excel;
 
    //Open the template workbook with dummy data
    IWorkbook workbook = application.Workbooks.Open("TemplateData.xlsx", ExcelOpenType.Automatic);
 
    //Accessing the first worksheet
    IWorksheet worksheet = workbook.Worksheets[0];
 
    //Check if the ranges "C1:G10" and "D3:Q6" intersect
    IRange intersectRange = worksheet.IntersectRanges(worksheet.Range["C1:G10"], worksheet.Range["D3:Q6"]);
    if( intersectRange != null)
    {
        Console.WriteLine("true");
        Console.WriteLine("Intersecting range: " + intersectRange.AddressLocal);
        Console.ReadKey();
    }
    else
    {
        Console.WriteLine("false");
        Console.ReadKey();
    }
}

Using excelEngine As ExcelEngine = New ExcelEngine()
    'Instantiate the application object
    Dim application As IApplication = excelEngine.Excel
 
    'Open the template workbook with dummy data
    Dim workbook As IWorkbook = application.Workbooks.Open("TemplateData.xlsx", ExcelOpenType.Automatic)
 
    'Accessing the first worksheet
    Dim worksheet As IWorksheet = workbook.Worksheets(0)
 
    'Check if the ranges "C1:G10" and "D3:Q6" intersect
    Dim intersectRange As IRange = worksheet.IntersectRanges(worksheet.Range("C1:G10"), worksheet.Range("D3:Q6"))
    If intersectRange IsNot Nothing Then
        Console.WriteLine("true")
        Console.WriteLine("Intersecting range: " + intersectRange.AddressLocal)
        Console.ReadKey()
    Else
        Console.WriteLine("false")
        Console.ReadKey()
    End If
End Using