<%@ 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>
<asp
ataGridid=DataGrid runat="server"/>\
</body>
</html>
<%@ 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>
<asp
</body>
</html>
No comments:
Post a Comment