how to open excel file in vs2010 in windows form application

ashwini patel

9y2kWindows Forms

hello,,,,,,,,,

tell me how to open a excel file in windows form

In windows form1 - 1 button is there if a button1 pressed it will goto excel how???????

im tried soo many codeing but its not working plss tell me how to do and code for it

its urgent plss tell me frnds

5 Replies

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

Rajkiran Swain9y ago
Accepted answer
1. using System.Windows.Forms;
2. using Excel = Microsoft.Office.Interop.Excel;
4. namespace WindowsApplication1
5. {
6. public partial class Form1 : Form
7. {
8. public Form1()
9. {
10. InitializeComponent();
11. }
13. private void button1_Click(object sender, EventArgs e)
14. {
15. Excel.Application xlApp ;
16. Excel.Workbook xlWorkBook ;
17. Excel.Worksheet xlWorkSheet ;
18. object misValue = System.Reflection.Missing.Value;
20. xlApp = new Excel.Application();
21. xlWorkBook = xlApp.Workbooks.Open("csharp.net-informations.xls", 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
22. xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
24. MessageBox.Show(xlWorkSheet.get_Range("A1","A1").Value2.ToString());
26. xlWorkBook.Close(true, misValue, misValue);
27. xlApp.Quit();
29. releaseObject(xlWorkSheet);
30. releaseObject(xlWorkBook);
31. releaseObject(xlApp);
32. }
34. private void releaseObject(object obj)
35. {
36. try
37. {
38. System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);
39. obj = null;
40. }
41. catch (Exception ex)
42. {
43. obj = null;
44. MessageBox.Show("Unable to release the Object " + ex.ToString());
45. }
46. finally
47. {
48. GC.Collect();
49. }
50. }
51. }
52. }

ashwini patel9y ago

thank u all

alice yang9y ago

Hi,

You can use a component like Spire.Spreadsheet to view excel file in windows forms application.

https://www.e-iceblue.com/Introduce/spreadsheet-for-net.html

Jitendra Shekhawat9y ago

Try This Link......

https://social.msdn.microsoft.com/Forums/vstudio/en-US/e218d2a1-38ff-4e10-8026-bd866eee3005/make-visual-basic-2010-open-and-read-excel-data?forum=vsto

http://www.c-sharpcorner.com/UploadFile/6b8651/read-excel-file-in-windows-application-using-C-Sharp/

https://stackoverflow.com/questions/464902/how-to-open-an-excel-file-in-c

Zakir Ahamed9y ago

this article will help you:

http://www.c-sharpcorner.com/UploadFile/6b8651/read-excel-file-in-windows-application-using-C-Sharp/