hello guyz i need your help, i cannot import excel to datagridview in c#.net even though I add a reference using Microsoft.Office.Interlop.Excel , I m using a visual studio 2010 and this is my source code
- private void button1_Click(object sender, EventArgs e)    
- {    
-     _Application importExcelToDataGridViewAppl;    
-     _Workbook importExcelToDataGridViewWorkbook;    
-     _Worksheet importExcelToDataGridViewWorksheet;    
-     Range importExcelToDataGridViewRange;    
-     try    
-     {    
-         importExcelToDataGridViewAppl = new Microsoft.Office.Interop.Excel.Application();    
-         OpenFileDialog importExcelToDataGridViewFileDialog = new OpenFileDialog();    
-         importExcelToDataGridViewFileDialog.Title= "yahoo";    
-         importExcelToDataGridViewFileDialog.Filter = "Choose Excel File | *.xlsx;*.xls;*.xlsm";    
-          
-         if (importExcelToDataGridViewFileDialog.ShowDialog() == DialogResult.OK)    
-         {    
-             importExcelToDataGridViewWorkbook = importExcelToDataGridViewAppl.Workbooks.Open(importExcelToDataGridViewFileDialog.FileName);    
-             importExcelToDataGridViewWorksheet = importExcelToDataGridViewWorkbook.ActiveSheet;    
-             importExcelToDataGridViewRange = importExcelToDataGridViewWorksheet.UsedRange;    
-   
-               
-             for (int excelWorkSheetRowIndex=0;excelWorkSheetRowIndex < importExcelToDataGridViewRange.Rows.Count; excelWorkSheetRowIndex++)    
-             {    
-                 dataGridView1.Rows.Add(importExcelToDataGridViewWorksheet.Cells[excelWorkSheetRowIndex,1].Value,);    
-   
-             }    
-   
-         }    
-     }    
-     catch (Exception ex)    
-     {    
-     }    
-     finally    
-     {    
-     }    
-   
- }