ASP.NET Excel 导入数据库

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Excel = Microsoft.Office.Interop.Excel;//引入命名空间

namespace MyWeb
{
    public partial class UserList : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void btnImport_Click(object sender, EventArgs e)
        {
            string path = fileUser.Value;
            if (string.IsNullOrEmpty(path)) return;
            Excel.Application app = new Excel.Application();
            app.Visible = false;
            Excel.Workbook workBook = app.Workbooks.Open(path);//打开worksheet
            Excel.Worksheet workSheet = (Excel.Worksheet)workBook.Sheets[1];//创建worksheet1
            for (int i = 2; i <= workSheet.UsedRange.Rows.Count; i++)//循环读取每一行列值
            {
                Object obj1 = ((Excel.Range)workSheet.Rows.Cells[i, 1]).Value;
                Object obj2 = ((Excel.Range)workSheet.Rows.Cells[i, 2]).Value;
                Object obj3 = ((Excel.Range)workSheet.Rows.Cells[i, 3]).Value;
            }

           workBook = null;
           workSheet = null;
           app = null;
           GC.Collect();
        }

    }

在这里面，我只列出了，从Excel中读取每一行的值，至于保存数据库就比较容易了，这里就不写了，希望对需要人有所帮助!