Open excel on winform in C#

Ranjit Powar

In my project I have create excel file on button click event but it opens in Microsoft office. I want to open that excel in other windows form when I click on button not in Microsoft office Excel. Please tell me how I do this??

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kyle Story11y ago
Hi, well two things come to my mind and I hope they can help you out.

First you can implement an Excel interface in your WinForms application by using the WebBrowser control, see here.

Second you can create your own interface with a DataGridView control, for example I used this .NET library for excel files as a bridge between the file and the control. It has a straightforward API for both importing and exporting excel file's data to DataGridView control. Also you can find here an example of WinForms application.
Vulpes12y ago
In my experience trying to embed complex unmanaged applications within a managed windows form seldom works well but, if you still want to try, the basic code is as follows:

using System.Runtime.InteropServices;
using System.Diagnostics;

// ....

[DllImport("user32.dll")]
private static extern IntPtr SetParent(IntPtr hWndChild, IntPtr hWndNewParent);

private void button1_Click(object sender, EventArgs e)
{
Process p = Process.Start("excel.exe");

if (p != null)
{
p.WaitForInputIdle(); // make sure main window handle is created
SetParent(p.MainWindowHandle, this.Handle);
}
}
Ranjit Powar12y ago
i want to embed excel on winform please help.
Wim Sturkenboom12y ago
Use your favorite search engine and search for c# read excel spreadsheet. You will find plenty of examples :)