//===============================================================================
//?編寫：楚旋
//?博客：http://eflylab.cnblogs.com
//?時間：2008-04-17
//==============================================================================
using?System;
using?System.Data;
using?System.Configuration;
using?System.Web;
using?System.Web.Security;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Web.UI.WebControls.WebParts;
using?System.Web.UI.HtmlControls;
using?System.Data.OleDb;
public?partial?class?_Default?:?System.Web.UI.Page?
{
????
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
???????
????}

????private?void?BindData（DataTable?dt）
????{
????????repData.DataSource?=?dt;
????????repData.DataBind（）;
????}
????protected?void?btnLoadDt_Click（object?sender?EventArgs?e）
????{
????????BindData（LoadDataTable（））;
????}

????//創建DataTable
????private?DataTable?LoadDataTable（）
????{
????????DataTable?dt?=?new?DataTable（）;
????????DataColumn?dc?=?new?DataColumn（“userName“）;
????????dt.Columns.Add（dc）;
????????dc?=?new?DataColumn（“userSex“）;
????????dt.Columns.Add（dc）;

????????DataRow?dr?=?dt.NewRow（）;
????????dr[0]?=?“fengyan“;
????????dr[1]?=?“male“;
????????dt.Rows.Add（dr）;

????????dr?=?dt.NewRow（）;
????????dr[0]?=?“efly“;
????????dr[1]?=?“male“;
????????dt.Rows.Add（dr）;

????????dr?=?dt.NewRow（）;
????????dr[0]?=?“楚旋“;
????????dr[1]?=?“male“;
????????dt.Rows.Add（dr）;
????????
????????dr?=?dt.NewRow（）;
????????dr[0]?=?“51aspx“;
????????dr[1]?=?“male“;
????????dt.Rows.Add（dr）;

????????return?dt;
????}

????protected?void?btnExportExcel_Click（object?sender?EventArgs?e）
????{
????????//得到需要導入Excel的DataTable
????????DataTable?dt?=?LoadDataTable（）;
????????//將其列名添加進去！?（這一步注意是為了方便以后將該Excel導入內存表中?自動創建列名用。）
????????//DataRow?dr?=?dt.NewRow（）;
????????//dr[0]?=?“userName“;
????????//dr[1]?=?“userSex“;
????????//dt.Rows.InsertAt（dr?0）;

????????//實例化一個Excel助手工具類
????????ExcelHelper?ex?=?new?ExcelHelper（）;
????????//導入所有！（從第一行第一列開始）
????????ex.DataTableToExcel（dt?1?1）;
????????//導出Excel保存的路徑！
????????ex.OutputFilePath?=?txtExcelPath.Text;
????????ex.OutputExcelFile（）;????????
????????
????}
??
????protected?void?btnExcelToDataTable_Click（object?sender?EventArgs?e）
????{
????????string?strConn?=?“Provider=Microsoft.Jet.OLEDB.4.0;Data?Source=“?+?txtFromExcel.Text?+?“;Extended?Properties=Excel?8.0“;
????????//鏈接Excel
????????OleDbConnection?cnnxls?=?new?OleDbConnection（strConn）;
????????//讀取Excel里面有?表Sheet1
????????OleDbDataAdapter?oda?=?new?OleDbDataAdapter（“select?*?from?[Sheet1$]“?cnnxls）;
????????DataSet?ds?=?new?DataSet（）;
????????//將Excel里面有表內容裝載到內存表中！
????????oda.Fill（ds）;
????????DataTable?dt?=?ds.Tables[0];
????????BindData（dt）;
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1643??2008-08-26?11:36??ExcelHelper\51aspx源碼必讀.txt

?????文件??????82495??2008-08-26?11:34??ExcelHelper\App_Code\ExcelHelper.cs

?????文件?????942080??2005-05-13?16:08??ExcelHelper\Bin\Interop.Excel.dll

?????文件??????13824??2008-08-26?11:23??ExcelHelper\DataTableToExcel.xls

?????文件???????2157??2008-04-17?10:05??ExcelHelper\Default.aspx

?????文件???????3037??2008-08-26?11:24??ExcelHelper\Default.aspx.cs

?????文件??????82437??2009-03-11?14:12??ExcelHelper\ExcelHelper\ExcelHelper\App_Code\ExcelHelper.cs

?????文件?????942080??2005-05-13?16:08??ExcelHelper\ExcelHelper\ExcelHelper\Bin\Interop.Excel.dll

?????文件??????13824??2008-08-26?11:23??ExcelHelper\ExcelHelper\ExcelHelper\DataTableToExcel.xls

?????文件???????2157??2008-04-17?10:05??ExcelHelper\ExcelHelper\ExcelHelper\Default.aspx

?????文件???????3037??2008-08-26?11:24??ExcelHelper\ExcelHelper\ExcelHelper\Default.aspx.cs

?????文件???????1598??2008-07-11?22:18??ExcelHelper\ExcelHelper\ExcelHelper\Web.Config

?????文件?????????84??2008-11-07?16:52??ExcelHelper\ExcelHelper\ExcelHelper\說明.txt

?????文件???????1484??2008-11-07?17:00??ExcelHelper\ExcelHelper\ExcelHelper.sln

????..A..H.?????13824??2009-03-13?17:36??ExcelHelper\ExcelHelper\ExcelHelper.suo

?????文件???????4945??2007-07-18?09:38??ExcelHelper\from.gif

?????文件???????1598??2008-07-11?22:18??ExcelHelper\Web.Config

?????文件????????125??2007-03-27?14:33??ExcelHelper\最新Asp.Net源碼下載.url

?????目錄??????????0??2009-03-11?14:12??ExcelHelper\ExcelHelper\ExcelHelper\App_Code

?????目錄??????????0??2008-08-26?11:21??ExcelHelper\ExcelHelper\ExcelHelper\App_Data

?????目錄??????????0??2008-08-26?11:21??ExcelHelper\ExcelHelper\ExcelHelper\Bin

?????目錄??????????0??2008-11-07?16:48??ExcelHelper\ExcelHelper\ExcelHelper

?????目錄??????????0??2008-08-26?11:21??ExcelHelper\App_Code

?????目錄??????????0??2008-08-26?11:21??ExcelHelper\App_Data

?????目錄??????????0??2008-08-26?11:21??ExcelHelper\Bin

?????目錄??????????0??2008-11-07?17:00??ExcelHelper\ExcelHelper

?????目錄??????????0??2009-03-11?13:31??ExcelHelper

-----------?---------??----------?-----??----

??????????????2112429????????????????????27



............此處省略0個文件信息