Thursday, November 24, 2011

Importing Excel Data in Asp.Net

<%@ Page Language="C#" %>
<%@ ImportNamespace="System.Data.OleDb" %>
<%@ ImportNamespace="System.Data" %>
<%@ Import Namespace="System" %>
<scriptlanguage="C#" runat="server">
protected void Page_Load(ObjectSrc, EventArgs E)
{
string strConn;
strConn ="Provider=Microsoft.Jet.OLEDB.4.0;" +
"DataSource=C:\\excel.xls;" +
"Extended Properties=Excel 8.0;";
//Youmust use the $ after the object you reference 

// in the spreadsheet
OleDbDataAdaptermyCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]",strConn);

DataSetmyDataSet = new DataSet();
myCommand.Fill(myDataSet, "ExcelInfo");
DataGrid1.DataSource= myDataSet.Tables["ExcelInfo"].DefaultView;
DataGrid1.DataBind();
}
</script>
<html>
<head></head>
<body>
<p><asp:Labelid=Labelrunat="server">Spread  Sheet  Contents:</asp:Label></p>
<aspataGridid=DataGrid runat="server"/>\
</body>
</html>

No comments:

Post a Comment