.net excel导入mysql_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中读取每一行的值，至于保存数据库就比较容易了，这里就不写了，希望对需要人有所帮助!