Asp.net|excel vb.net Source Code
<%@ Page language= "VB"%>
<%@ Import namespace= "System.Data"%>
<%@ Import namespace= "System.Data.Oledb"%>
<script language= "VB" runat= "Server" >
Sub Page_Load (sender as Object, E as EventArgs)
Dim myDataSet as New DataSet ()
"We can use Excel ODBC driver
Dim strconn as String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\exceltest.xls;" & _
"Extended properties=" "Excel 8.0;" ""
"We must use $ behind the sheet
Dim MyData as New oledbdataadapter ("select * from [sheet1$]", strconn)
MYDATA.TABLEMAPPINGS.ADD ("Table", "Exceltest")
Mydata.fill (myDataSet)
DataGrid1.DataSource = mydataset.tables (0). DefaultView
Datagrid1.databind ()
End Sub
</script>
<body>
<p><asp:label id=label1 runat= "Server" >spreadsheet contents:</asp:label></p>
<asp:datagrid id=datagrid1 runat= "Server"/>\
</body>
C # Syntax
<%@ 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;";
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>
<body>
<p><asp:label id=label1 runat= "Server" >spreadsheet contents:</asp:label></p>
<asp:datagrid id=datagrid1 runat= "Server"/>\
</body>
