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.
Unfortunately, activation email could not send to your email. Please try again.

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

Thread ID:

Created:

Platform:

Replies:

3772 Apr 7,2003 09:37 PM Windows Forms 0
loading
Tags: FAQ
.net beginner
Asked On April 7, 2003 09:37 PM

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() }

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;