We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

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