Open Excel in C#, VB.NET

using Syncfusion.XlsIO;

Imports Syncfusion.XlsIO

//Instantiate the spreadsheet creation engine
using (ExcelEngine excelEngine = new ExcelEngine())
{
    //Initialize application
    IApplication app = excelEngine.Excel;
 
    //Set default application version as Excel 2016
    app.DefaultVersion = ExcelVersion.Excel2016;
 
    //Open existing Excel workbook from the specified location
    string inputFileName = "Sample.xlsx";
    IWorkbook workbook = app.Workbooks.Open(inputFileName, ExcelOpenType.Automatic);
 
    //Access the first worksheet
    IWorksheet worksheet = workbook.Worksheets[0];
 
    //Read number value
    int id = (int)worksheet["A2"].Number;
 
    //Read text value
    string name = worksheet["B2"].Text;
 
    //Read date value
    DateTime dob = worksheet["C2"].DateTime;
 
    //Read formula
    string ageFormula = worksheet["D2"].Formula;
 
    //Enable calculations
    worksheet.EnableSheetCalculations();
 
    //Read calculated value
    string formulaValue = worksheet["D2"].CalculatedValue;
 
    //Get display text
    string displayText = worksheet["C2"].DisplayText;
 
    //Save the Excel workbook to disk in xlsx format
    workbook.SaveAs("Output.xlsx");
 
    //Print the values that are read from the Excel file
    Console.WriteLine("Number in cell A2: {0}", id);
    Console.WriteLine("Text in cell B2: {0}", name);
    Console.WriteLine("DateTime in cell C2: {0}", dob);
    Console.WriteLine("Formula in cell D2: {0}", ageFormula);
    Console.WriteLine("Calculated formula value in cell D2: {0}", formulaValue);
    Console.WriteLine("Display text in cell C2: {0}", displayText);
    Console.Read();
}

'Instantiate the spreadsheet creation engine
Using excelEngine As ExcelEngine = New ExcelEngine
 
    'Initialize application
    Dim app As IApplication = excelEngine.Excel
 
    'Set default application version as Excel 2016
    app.DefaultVersion = ExcelVersion.Excel2016
 
    'Open existing Excel workbook from the specified location
    Dim inputFileName As String = "Sample.xlsx"
    Dim workbook As IWorkbook = app.Workbooks.Open(inputFileName, ExcelOpenType.Automatic)
 
    'Access the first worksheet
    Dim worksheet As IWorksheet = workbook.Worksheets(0)
 
    'Read number value
    Dim id As Integer = CInt(worksheet("A2").Number)
 
    'Read text value
    Dim name As String = worksheet("B2").Text
 
    'Read date value
    Dim dob As DateTime = worksheet("C2").DateTime
 
    'Read formula
    Dim ageFormula As String = worksheet("D2").Formula
 
    'Enable calculations
    worksheet.EnableSheetCalculations()
 
    'Read calculated value
    Dim formulaValue As String = worksheet("D2").CalculatedValue
 
    'Get display text
    Dim displayText As String = worksheet("C2").DisplayText
 
    'Save the Excel workbook to disk in xlsx format
    workbook.SaveAs("Output.xlsx")
 
    'Print the values that are read from the Excel file
    Console.WriteLine("Number in cell A2: {0}", id)
    Console.WriteLine("Text in cell B2: {0}", name)
    Console.WriteLine("DateTime in cell C2: {0}", dob)
    Console.WriteLine("Formula in cell D2: {0}", ageFormula)
    Console.WriteLine("Calculated formula value in cell D2: {0}", formulaValue)
    Console.WriteLine("Display text in cell C2: {0}", displayText)
    Console.Read()
End Using