This code will read data from excelsheet in gridview......t ake a submit button and take a datagrid....and use below code...its works fine....


Code:
private void btnsubmit_Click(object sender, EventArgs e)
        {
          
                Excel.Application appExl;
                Excel.Workbook workbook;
                Excel.Worksheet NwSheet;
                Excel.Range ShtRange;
...