How to open an Excel file in C

Question

My goal is to translate some VBA code into C#. C# is new to me. Currently, I am trying to access an Excel file from a folder and if it does not exist then create it. I am trying something like the following. How do I make it function?

Excel.Application objexcel;
Excel.Workbook wbexcel;
bool wbexists;
Excel.Worksheet objsht;
Excel.Range objrange;

objexcel = new Excel.Application();
if (Directory("C:\\csharp\\error report1.xls") = "")
{
    wbexcel.NewSheet();
}

else
{
    wbexcel.Open("C:\\csharp\\error report1.xls");
    objsht = ("sheet1");
}
objsht.Activate();

Answer 1

You must have Microsoft Visual Studio Tools for Office installed (VSTO).

In the Visual Studio installer, choose VSTO from the Workloads > Web & Cloud > Office/SharePoint Development menu.

Then, using the 'Add Reference... > Assemblies' window, create a generic.NET project and reference Microsoft.Office.Interop.Excel in it.

Application excel = new Application();
Workbook wb = excel.Workbooks.Open(path);

Missing.Value is a special reflection struct for unnecessary parameters replacement