How to create a excel file in C# without visitable to Excel window

I am using the following code to open a Excel window but I don't know how to open a sheet and set value on it and close it. Thanks in advance. //Variable Type excel; object[] parameter= new object[1]; object excelObject; try { //Get the excel object excel = Type.GetTypeFromProgID("Excel.Application"); //Create instance of excel excelObject = Activator.CreateInstance(excel); //Set the parameter whic u want to set parameter[0] = true; //Set the Visible property excel.InvokeMember("Visible", BindingFlags.SetProperty, null, excelObject, parameter); } catch(Exception e) { Console.WriteLine("Error Stack {0} ", e.Message) ; } finally { //When this object is destroyed the Excel application will be closed //So Sleep for sometime and see the excel application Thread.Sleep(5000); //Relaese the object //GC.RunFinalizers() }

Loader.
Up arrow icon