下面的代码展示了如何将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>
<%@ 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();
}
{
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();
}