Skip to main content

Importing data from excel 2003 file in a gridview in asp.net c#

In this article you will see how to import given sheet from excel 2003 file into dataset and then display this data into girdview.

Below is the code for import data from given sheet named Sheet1$ into dataset then bind it to gridview, change sheet name as per your excel sheet name you have to ad suffix $ in sheet name.

Importing data from Sheet1$ of excel 2003 file code -


private void btnImportExcelToGridview_Click(object sender, System.EventArgs e)
 {
        String strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
        "Data Source="+Server.MapPath(@"File/Book1.xls")+
        "Extended Properties=Excel 8.0;";

        DataSet ds = new DataSet();
        //You must use the $ after the object
        //you reference in the spreadsheet
        OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn);

         da.Fill(ds);
         Gridview1.DataSource = ds.Tables[0].DefaultView;
         Gridview1.DataBind();
 }




Popular posts from this blog

Merging multiple PDFs using iTextSharp in asp.net c#

In this article i will show you how to merge multiple pdfs into one using ITextSharp below is the two approach one is to pass your input files path, output file path (will be created if not exist) and another is pass direct input stream, output stream and it will write the merge files into output stream.

Uploading large file in chunks in Asp.net Mvc c# from Javascript ajax

Often we have a requirement to upload files in Asp.net, Mvc c# application but when it comes to uploading larger file, we always think how to do it as uploading large file in one go have many challenges like UI responsiveness, If network fluctuate for a moment in between then uploading task get breaks and user have to upload it again etc.

how $document.ready() is different from window.onload()

we often use window.onload() in javascript and $document.ready() in jquery and assume that both are same just jquery library wrap up javascript window.onload() and introduce $document.ready() but no there is much difference between them below is the explanation -

Scrollable Gridview with fixed headers in asp.net

horizontal and vertical scrollable Gridview with static header row.fixed header in gridview in asp.net.static header in gridview through java script.I was looking for a solution for this for a long time and found most of the answers are not working or not suitable for my situation i also find most of the java script code for that they worked but only with the vertical scroll not with the horizontal scroll and also combination of header and rows doesn't match.