public void btnBrowse_Click(object sender, EventArgs e) { string ExcelFile; int TotalSheets; Excel.Application Exapp; Microsoft.Office.Interop.Excel.Workbook Myworkbook; cbmFile.Items.Clear(); txtFile.Text = ""; try { OpenFileDialog1.Filter = "Excel Files (*.xls)|*.xls|All Files(*.*)|*.*"; OpenFileDialog1.InitialDirectory = @"c:\"; OpenFileDialog1.FileName = "Select File"; OpenFileDialog1.Title = "Select excel file.."; OpenFileDialog1.ShowDialog(); ExcelFile = OpenFileDialog1.FileName; ; txtFile.Text = ExcelFile; Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel.Workbook workbook = Exapp.Workbooks.Open(ExcelFile, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0); TotalSheets = Myworkbook.Worksheets.Count; foreach (Excel.Worksheet wksh in Myworkbook.Worksheets) { cbmFile.Items.Add(wksh.Name); } Myworkbook.Close(false, false, false); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)