How to Import All Excel Sheet in Gridview in asp.net?

Question

I have created an attendance sheet in excel and i want to display all sheets like class attendance report,students attendance report etc in gridview,can anybody help me?

You have multiple sheets ? – Suraj Singh Dec 05 '13 at 09:13 — Suraj Singh, Dec 05 '13 at 09:13
Yes I have 4 sheets in excel. – Ashraf Ali Dec 06 '13 at 06:51 — Ashraf Ali, Dec 06 '13 at 06:51

score 0 · Answer 1 · edited May 23 '17 at 12:16

0

You should import your sheets into a DataSet object, and then bind it to a GridView.
Take a look at those links:
Excel Sheet to DataSet: link_1
Bind DataSet to Gridview: link_2

edited May 23 '17 at 12:16

Community

1
1

answered Dec 05 '13 at 09:19

Omer Eldan

1,757
1
11
10

score 0 · Answer 2 · edited Dec 05 '13 at 12:06

0

   List<string> excelName = new List<string>();   
   DataSet ds = new DataSet();  
   foreach(var name in excelName )
    {
        using (SqlConnection con = new SqlConnection(connectionString))
        {        
            DataTable dt = new DataTable();
            string query ="select * from '"+name+"'";
            con.Open();
            SqlDataAdapter da = new OleDbDataAdapter(query, con);
            da.Fill(dt);
            con.Close();    
            ds.add(dt);            
        }
    }

    gridview.DataSource = ds;
    gridview.DataBind();

edited Dec 05 '13 at 12:06

Omer Eldan

1,757
1
11
10

answered Dec 05 '13 at 09:19

Suraj Singh

4,041
1
21
36

If i supposed to select this file from my system and on button click i wanna see,where i have to write this code? – Ashraf Ali Dec 06 '13 at 06:58
@user3069405 You can have a look at this http://stackoverflow.com/questions/17568604/import-excel-data-to-datagridview-in-visual-studio-2010 – Suraj Singh Dec 06 '13 at 07:10

How to Import All Excel Sheet in Gridview in asp.net?

2 Answers2