List导入Excel文件

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.Office.Interop.Excel;
using System.Web;
using System.IO;
using eName.App.Config;
using System.Data.OleDb;
using System.Data.Odbc;
using ServerHoldUnlock.Info.Table;

namespace ServerHoldUnlock.Libs
{
 public class Excels
 {
  public string CopyExcel()
  {
   string name = DateTime.Now.ToString("yyyyMMddHHmmss");
   string path = string.Format(AppSetting.Path,name);
   System.IO.File.Copy(System.Web.HttpContext.Current.Server.MapPath("~/App_Data/Excel/Sample.xls"), System.Web.HttpContext.Current.Server.MapPath(path));

   return name;
  }
  public void DateToExcel(List<ServerHoldUnlockTable> list, string name)
  {
   string path = string.Format(AppSetting.Path, name);
   string strCon = string.Format("Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source ={0};Extended Properties=Excel 8.0", System.Web.HttpContext.Current.Server.MapPath(path));
   OleDbConnection myConn = new OleDbConnection(strCon);
   try
   {
    myConn.Open();

    for (int i = 0; i < list.Count; i++)
    {
     string sql = string.Format("INSERT INTO [Sheet1$] VALUES('{0}','{1}')", list[i].Domain, list[i].ICP);
     using (OleDbCommand comm = new OleDbCommand(sql, myConn))
     {
      comm.ExecuteNonQuery();
     }
    }

    myConn.Close();
    myConn.Dispose();
   }
   catch
   {
    myConn.Close();
    myConn.Dispose();
   }
  }

  /// <summary>
  /// 从web页面下载文件
  /// </summary>
  /// <param name="strFile">要下载文件的绝对路径</param>
  public void DownloadFile(string strFile)
  {
   HttpContext.Current.Response.Clear();
   HttpContext.Current.Response.ContentType = "application/octet-stream";
   HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=\"" + HttpUtility.UrlEncode(Path.GetFileName(strFile).Trim()) + "\"");
   HttpContext.Current.Response.Flush();

   HttpContext.Current.Response.WriteFile(strFile);
   HttpContext.Current.Response.End();
  }
 }
}
事先要创建好Excel的模板,程序复制调用