how to open excel file in vs2010 in windows form application

Question

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 c ode for it its urgent plss tell me frnds

Rajkiran Swain · Answer

using System.Windows.Forms; using Excel = Microsoft.Office.Interop.Excel; namespace WindowsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click( object sender EventArgs e) { Excel.Application xlApp ; Excel.Workbook xlWorkBook ; Excel.Worksheet xlWorkSheet ; object misValue = System.Reflection.Missing.Value; xlApp = new Excel.Application(); xlWorkBook = xlApp.Workbooks.Open( csharp.net-informations.xls  0 true  5     true  Microsoft.Office.Interop.Excel.XlPlatform.xlWindows 	  false  false  0 true  1 0); xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); MessageBox.Show(xlWorkSheet.get_Range( A1  A1 ).Value2.ToString()); xlWorkBook.Close( true  misValue misValue); xlApp.Quit(); releaseObject(xlWorkSheet); releaseObject(xlWorkBook); releaseObject(xlApp); } private void releaseObject( object obj) { try { System.Runtime.InteropServices.Marshal.ReleaseComObject(obj); obj = null ; } catch (Exception ex) { obj = null ; MessageBox.Show( Unable to release the Object  + ex.ToString()); } finally { GC.Collect(); } } } }

ashwini patel · Answer

thank u all

alice yang · Answer

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

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

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