Open excel on winform in C#

Question

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??

Kyle Story · Answer

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.

Vulpes · Answer

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 Powar · Answer

i want to embed excel on winform please help.

Wim Sturkenboom · Answer

Use your favorite search engine and search for c# read excel spreadsheet . You will find plenty of examples :)

Open excel on winform in C#

Answers (4)