下面的代码展示了如何将Excel内容显示到GridView中:
aspx代码:
.aspx<%
@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="TCQA.Web._Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" ><head runat="server"> <title>操作Excel</title></head><body> <form id="form1" runat="server"> <input type="file" id="f_path" runat="server" /> <asp:Button ID="btnImport" runat="server" Text="导入" OnClick="btnImport_Click" /> <asp:GridView ID="gv_list" runat="Server" AutoGenerateColumns="true"> </asp:GridView> </form></body></html>.cs代码:
protected void btnImport_Click(object sender, EventArgs e) {
string Path = f_path.Value; string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Path + ";" + "Extended Properties=Excel 8.0;"; OleDbConnection conn = new OleDbConnection(strConn); conn.Open(); string strExcel = ""; OleDbDataAdapter myCommand = null; DataSet ds = null; strExcel = "select * from [sheet1$]"; myCommand = new OleDbDataAdapter(strExcel, strConn); ds = new DataSet(); myCommand.Fill(ds, "table1"); gv_list.DataSource = ds; gv_list.DataBind();
}