Read excel file using C#

Posted Date: 21 Oct 2009	Resource Type: Code Snippets	Category: ASP.NET WebForms
Author: Lalji	Member Level: Diamond
Rating:	Points: 6

Code Sample

<%@ Page Language="C#" %>

<%@ Import Namespace="System.Data.OleDb" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System" %>

<script language="C#" runat="server">
    protected void Page_Load(Object Src, EventArgs E)
    {
        string strConn;
        strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
        "Data Source=C:\\exceltest.xls;" +
        "Extended Properties=Excel 8.0;";
        //You must use the $ after the object you reference in the spreadsheet
        OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn);

        DataSet myDataSet = new DataSet();
        myCommand.Fill(myDataSet, "ExcelInfo");
        DataGrid1.DataSource = myDataSet.Tables["ExcelInfo"].DefaultView;
        DataGrid1.DataBind();
    }
</script>

<html>
<head>
</head>
<body>
    <p>
        <asp:Label ID="Label1" runat="server">SpreadSheetContents:</asp:Label></p>
    <asp:DataGrid ID="DataGrid1" runat="server" />\
</body>
</html>

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Read Excel File . Excelread using C# .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Maintain Checked State for CheckBoxList in ASP.NET
	Previous Resource: Operators difference between VB & C#
	Return to Discussion Resource Index
	Post New Resource
	Category: ASP.NET WebForms

Post resources and earn money!

More Resources