asp.net 获取excel工作溥数据与连接方法（vb.net,c#）

asp教程.net 获取excel工作溥数据与连接方法

c#读取excel数据表方法

void Page_Load(object sender, EventArgs e) {

string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:Yourspreadsheet.xls; Extended Properties=""Excel 8.0;HDR=Yes"";";
string CommandText = "select * from [Book$]";

OleDbConnection myConnection = new OleDbConnection(ConnectionString);
OleDbCommand myCommand = new OleDbCommand(CommandText, myConnection);

myConnection.Open();

DataGrid1.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
DataGrid1.DataBind();

myConnection.Close();
}

Simple Data Report

---

vb.net读取excel数据方法

Reading from an Excel Workbook

Dim strSQL As String = "SELECT * FROM Items WHERE Source='Dell'"
Dim objCommand As New OleDbCommand(strSQL, objConnection)

objConnection.Open()
dgInventory.DataSource = objCommand.ExecuteReader()
dgInventory.DataBind()
objConnection.Close()
End Sub