Extract Excel row to an array in C#, VB.NET

using Syncfusion.XlsIO;
using System;
using System.IO;
using System.Reflection;

Imports Syncfusion.XlsIO
Imports System.IO
Imports System.Reflection

using (ExcelEngine excelEngine = new ExcelEngine())
{
    // Instantiate the Excel application object
    IApplication application = excelEngine.Excel;
     // Load an existing Excel file into IWorkbook
    Assembly assembly = typeof(Program).GetTypeInfo().Assembly;
    Stream fileStream = assembly.GetManifestResourceStream("ExtractRow.Sample.xlsx");
    IWorkbook workbook = application.Workbooks.Open(fileStream, ExcelOpenType.Automatic);
     // Get the first worksheet in the workbook into IWorksheet
    IWorksheet worksheet = workbook.Worksheets[0];
     // Get the row and column length
    int rowCount = worksheet.UsedRange.Rows.Length;
    int columnCount = worksheet.UsedRange.Columns.Length;
     // Initialize a string array
    string[] rowValues = new string[columnCount];
     // Get the row to extract data from
    Console.WriteLine("Enter the row from which you want to extract data: ");
    int n = Convert.ToInt16(Console.ReadLine());
     // Get the values in the row into an array if the row is in the used range
    if (n <= rowCount)
    {
        Console.WriteLine("Values in the worksheet row are: ");
        for (int i = 0; i < columnCount; i++)
        {
            rowValues[i] = worksheet.Range[n, i + 1].Value;
            Console.WriteLine("rowValues[" + i.ToString() + "] = " + rowValues[i].ToString());
        }
    }
    else
    {
        Console.WriteLine("Row - " + n.ToString() + " is not in the used range of the worksheet and is empty");
    }
    Console.ReadLine();
}

Using excelEngine As ExcelEngine = New ExcelEngine()
    'Instantiate the Excel application object
    Dim application As IApplication = excelEngine.Excel
 
    'Load an existing Excel file into IWorkbook
    Dim assembly As Assembly = GetType(Module1).GetTypeInfo.Assembly
    Dim fileStream As Stream = assembly.GetManifestResourceStream("ExtractRow.Sample.xlsx")
    Dim workbook As IWorkbook = application.Workbooks.Open(fileStream, ExcelOpenType.Automatic)
 
    'Get the first worksheet in the workbook into IWorksheet
    Dim worksheet As IWorksheet = workbook.Worksheets(0)
 
    'Get the row and column length
    Dim rowCount As Integer = worksheet.UsedRange.Rows.Length
    Dim columnCount As Integer = worksheet.UsedRange.Columns.Length
 
    'Initialize a string array
    Dim rowValues() As String = New String(columnCount - 1) {}
 
    'Get the row to extract data from
    Console.WriteLine("Enter the row from which you want to extract data : ")
    Dim n As Integer = Convert.ToInt16(Console.ReadLine)
 
    'Get the values in row into array, if the row is in used range
    If (n <= rowCount) Then
        Console.WriteLine("Values in the worksheet row are : ")
        For i As Integer = 0 To columnCount - 1 Step 1
            rowValues(i) = worksheet.Range(n, i + 1).Value
            Console.WriteLine("rowValues[" + i.ToString() + "] = " + rowValues(i).ToString())
        Next
    Else
        Console.WriteLine("Row - " + n.ToString + " is not in the used range of worksheet and is empty")
    End If
 
    Console.ReadLine()
End Using