using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Web;
using?System.Web.UI;
using?System.Web.UI.WebControls;

using?System.Configuration;
using?System.Data.OleDb;
using?System.Data.SqlClient;
using?System.Data;
using?System.IO;

namespace?ImportExcel_Demo
{
????public?partial?class?ImportExcel?:?System.Web.UI.Page
????{
????????protected?void?Page_Load（object?sender?EventArgs?e）
????????{
????????????//添加顯示提醒信息框
????????????this.btn_Add.Attributes.Add（“onclick“?“javascript:document.getElementById（‘runing‘）.style.visibility=‘visible‘“）;

????????}

????????#region?隱藏提醒信息框
????????protected?override?void?OnPreRenderComplete（EventArgs?e）
????????{
????????????runing.style.Add（“visibility“?“hidden“）;
????????}
????????#endregion

????????#region?導(dǎo)入處理
????????protected?void?btn_Add_Click（object?sender?EventArgs?e）
????????{
????????????#region?上傳提醒
????????????if?（this.fileExcel.PostedFile.FileName.Length?==?0）
????????????{
????????????????excel_msg.Text?=?“導(dǎo)入返回信息：沒(méi)有選擇文件！“;
????????????????this.excel_msg.ForeColor?=?System.Drawing.Color.Red;
????????????????return;
????????????}

????????????//記錄導(dǎo)入耗時(shí)
????????????DateTime?time?=?DateTime.Now;

????????????Unitily.UploadFile_in?upfile?=?new?Unitily.UploadFile_in（）;
????????????upfile.UserId?=?“S9527“;
????????????upfile.Upload_Type?=?0;

????????????upfile.Save（this.fileExcel.PostedFile）;
????????????#endregion

????????????try
????????????{
????????????????//刪除多余的表頭行，注意刪除的順序必須為倒序
????????????????DeleteRow（upfile.FilePath?“Sheet1“?“0“）;

????????????????string?connectionString?=?ConfigurationSettings.AppSettings[“ConnectionString“].Replace（“True“?“False“）;
????????????????string?constr?=?@“Provider=Microsoft.Jet.OLEDB.4.0;Data?Source=“?+?upfile.FilePath?+?“;Extended?Properties=‘Excel?8.0;HDR=Yes;IMEX=1‘“;

????????????????string?sqlstr?=?“select?*?from?[Sheet1$]“;

????????????????#region?OleDb導(dǎo)入
????????????????using?（OleDbConnection?sourceConnection?=?new?OleDbConnection（constr））
????????????????{
????????????????????sourceConnection.Open（）;

????????????????????OleDbCommand?ocomm?=?new?OleDbCommand（sqlstr?sourceConnection）;
????????????????????OleDbDataReader?reader?=?ocomm.ExecuteReader（）;

????????????????????using?（SqlConnection?destinationConnection?=?new?SqlConnection（connectionString））
????????????????????{
????????????????????????destinationConnection.Open（）;

????????????????????????using?（SqlBulkCopy?bulkCopy?=?new?SqlBulkCopy（connectionString））
????????????????????????{
????????????????????????????bulkCopy.BatchSize?=?1000;//每次傳輸?shù)男袛?shù)
????????????????????????????bulkCopy.BulkCopyTimeout?=?3600;

????????????????????????????//文件Excel中的列與表tbl_cell_gh_temp中的列進(jìn)行對(duì)應(yīng)???
????????????????????????????//第一個(gè)參數(shù)為Excel中的字段???
????????????????????????????//第二個(gè)參數(shù)為tbl_cell_gh_temp中的字段

????????????????????????????bulkCopy.ColumnMappings.Add（“city_id“?“city_id“）;
??????????????????????????

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2014-02-24?10:08??極速導(dǎo)入Excel\
?????文件?????2290176??2014-02-22?15:15??極速導(dǎo)入Excel\Aspose.Cells.dll
?????文件???????53760??2014-02-22?14:38??極速導(dǎo)入Excel\Excel測(cè)試數(shù)據(jù).xls
?????目錄???????????0??2014-02-22?17:47??極速導(dǎo)入Excel\ImportExcel_Demo\
?????目錄???????????0??2014-02-22?17:48??極速導(dǎo)入Excel\ImportExcel_Demo\ImportExcel_Demo\
?????文件?????????938??2014-02-22?11:45??極速導(dǎo)入Excel\ImportExcel_Demo\ImportExcel_Demo.sln
?????文件???????29184??2014-02-22?17:31??極速導(dǎo)入Excel\ImportExcel_Demo\ImportExcel_Demo.suo
?????目錄???????????0??2014-02-22?11:45??極速導(dǎo)入Excel\ImportExcel_Demo\ImportExcel_Demo\App_Data\
?????目錄???????????0??2014-02-22?17:47??極速導(dǎo)入Excel\ImportExcel_Demo\ImportExcel_Demo\bin\
?????文件?????2290176??2014-02-22?15:15??極速導(dǎo)入Excel\ImportExcel_Demo\ImportExcel_Demo\bin\Aspose.Cells.dll
?????文件???????31744??2014-02-22?17:19??極速導(dǎo)入Excel\ImportExcel_Demo\ImportExcel_Demo\bin\ImportExcel_Demo.dll
?????文件???????77312??2014-02-22?17:19??極速導(dǎo)入Excel\ImportExcel_Demo\ImportExcel_Demo\bin\ImportExcel_Demo.pdb
?????目錄???????????0??2014-02-22?17:47??極速導(dǎo)入Excel\ImportExcel_Demo\ImportExcel_Demo\Images\
?????文件????????1215??2014-02-22?17:21??極速導(dǎo)入Excel\ImportExcel_Demo\ImportExcel_Demo\Images\load_info_flag.gif
?????文件????????2969??2014-02-22?12:00??極速導(dǎo)入Excel\ImportExcel_Demo\ImportExcel_Demo\Images\saveing.gif
?????文件????????3388??2014-02-22?17:21??極速導(dǎo)入Excel\ImportExcel_Demo\ImportExcel_Demo\ImportExcel.aspx
?????文件???????12558??2014-02-22?17:19??極速導(dǎo)入Excel\ImportExcel_Demo\ImportExcel_Demo\ImportExcel.aspx.cs
?????文件????????2888??2014-02-22?14:00??極速導(dǎo)入Excel\ImportExcel_Demo\ImportExcel_Demo\ImportExcel.aspx.designer.cs
?????文件???????46572??2014-02-22?17:31??極速導(dǎo)入Excel\ImportExcel_Demo\ImportExcel_Demo\ImportExcel_Demo.csproj
?????文件????????1170??2014-02-22?17:31??極速導(dǎo)入Excel\ImportExcel_Demo\ImportExcel_Demo\ImportExcel_Demo.csproj.user
?????目錄???????????0??2014-02-22?17:47??極速導(dǎo)入Excel\ImportExcel_Demo\ImportExcel_Demo\Models\
?????文件??????119573??2014-02-22?17:17??極速導(dǎo)入Excel\ImportExcel_Demo\ImportExcel_Demo\Models\SQLHelper.cs
?????目錄???????????0??2014-02-22?17:47??極速導(dǎo)入Excel\ImportExcel_Demo\ImportExcel_Demo\obj\
?????目錄???????????0??2014-02-22?17:47??極速導(dǎo)入Excel\ImportExcel_Demo\ImportExcel_Demo\obj\Debug\
?????文件???????70832??2014-02-22?17:21??極速導(dǎo)入Excel\ImportExcel_Demo\ImportExcel_Demo\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????文件?????????504??2014-02-22?17:13??極速導(dǎo)入Excel\ImportExcel_Demo\ImportExcel_Demo\obj\Debug\ImportExcel_Demo.csproj.FileListAbsolute.txt
?????文件???????31744??2014-02-22?17:19??極速導(dǎo)入Excel\ImportExcel_Demo\ImportExcel_Demo\obj\Debug\ImportExcel_Demo.dll
?????文件???????77312??2014-02-22?17:19??極速導(dǎo)入Excel\ImportExcel_Demo\ImportExcel_Demo\obj\Debug\ImportExcel_Demo.pdb
?????目錄???????????0??2014-02-22?11:45??極速導(dǎo)入Excel\ImportExcel_Demo\ImportExcel_Demo\obj\Debug\TempPE\
?????目錄???????????0??2014-02-22?17:47??極速導(dǎo)入Excel\ImportExcel_Demo\ImportExcel_Demo\Properties\
?????文件????????1333??2014-02-22?11:45??極速導(dǎo)入Excel\ImportExcel_Demo\ImportExcel_Demo\Properties\AssemblyInfo.cs
............此處省略802個(gè)文件信息