Default.aspx1
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>2
3
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">4
<html xmlns="http://www.w3.org/1999/xhtml">5
<head runat="server">6
<title>Untitled Page</title>7
</head>8
<body>9
<form id="form1" runat="server">10
<div>11
<table>12
<tr>13
<td>14
<asp:FileUpload ID="fuExcel" runat="server" />15
<asp:Button ID="btImport" runat="server" Text="Import" 16
onclick="btImport_Click" />17
</td>18
</tr>19
<tr>20
<td>21
<asp:PlaceHolder ID="phExcel" runat="server"></asp:PlaceHolder>22
</td>23
</tr>24
</table>25
</div>26
</form>27
</body>28
</html>Default.aspx.cs1
using System;2
using System.Configuration;3
using System.Data;4
using System.Linq;5
using System.Web;6
using System.Web.Security;7
using System.Web.UI;8
using System.Web.UI.HtmlControls;9
using System.Web.UI.WebControls;10
using System.Web.UI.WebControls.WebParts;11
using System.Xml.Linq;12
using Excel;13
using System.Collections;14
15
public partial class _Default : System.Web.UI.Page16
{17
protected void Page_Load(object sender, EventArgs e)18
{19
20
}21
protected void btImport_Click(object sender, EventArgs e)22
{23
ArrayList al = Excels.ExcelSheetName(fuExcel.PostedFile.FileName);24
foreach (string str in al)25
{26
DataTable dt = Excels.ExcelDataSource(fuExcel.PostedFile.FileName, str);27
PlaceHolder PHOption = (PlaceHolder)this.FindControl("phExcel");28
Label lb = new Label();29
lb.ID = "lb" + str;30
lb.Text = str;31
GridView gv = new GridView();32
gv.Visible = true;33
gv.ID = "gv" + str;34
this.phExcel.Controls.Add(lb);35
this.phExcel.Controls.Add(gv);36
gv.DataSource = dt;37
gv.DataBind();38
}39
}40
}41
Excel.csusing System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Collections;
using System.Data.OleDb;
/// <summary>
/// Summary description for Excel
/// </summary>
namespace Excel
{
public class Excels
{
public static DataTable ExcelDataSource(string filepath, string sheetname)
{
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath + ";Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
OleDbDataAdapter oada = new OleDbDataAdapter("select * from [" + sheetname + "]", strConn);
DataTable dt = new DataTable();
oada.Fill(dt);
return dt;
}
public static ArrayList ExcelSheetName(string filepath)
{
ArrayList al = new ArrayList();
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath + ";Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
DataTable sheetNames = conn.GetOleDbSchemaTable
(System.Data.OleDb.OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
conn.Close();
foreach (DataRow dr in sheetNames.Rows)
{
al.Add(dr[2]);
}
return al;
}
}
}
