npoi excel导入html数据库,利用NPOI读取Execl数据插入数据库

usingNPOI.HSSF.UserModel;usingNPOI.XSSF.UserModel;usingNPOI.SS.UserModel;usingSystem;usingSystem.Collections.Generic;usingSystem.Data.SqlClient;usingSystem.IO;usingSystem.Linq;usingSystem.Web;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;public partial class导入到数据库 : System.Web.UI.Page

{protected void Page_Load(objectsender, EventArgs e)

{

}protected void Button1_Click(objectsender, EventArgs e)

{

IWorkbook workbook=null;if(FileUpload1.HasFile)

{string filePath = Server.MapPath("~/Files/");//先要创建项目文件夹Files

string fileName =FileUpload1.PostedFile.FileName;

FileUpload1.SaveAs(filePath+ fileName);//存到项目文件夹下

string fileExt =Path.GetExtension(fileName);using (FileStream fileReader = File.OpenRead(filePath +fileName))

{//创建工作簿对象接收文件流(Excel信息)

try{using (var file = new FileStream(filePath+fileName, FileMode.Open, FileAccess.Read))

{if (fileExt == ".xls")

{

workbook= newHSSFWorkbook(file);

}else if (fileExt == ".xlsx")

{

workbook= newXSSFWorkbook(file);

}

ISheet sheet= workbook.GetSheetAt(0);int ii = 1;//r = 2,剔除表头2行

for (int r = 2; r <= sheet.LastRowNum; r++)

{//定义参数数组para//创建一行获取sheet行数据

IRow row =sheet.GetRow(r);string a = row.GetCell(0).ToString();//excel中的第一个单元格数据

string b = row.GetCell(12).ToString();//excel中的第12个单元格数据

//{这里使用的你自己的orm框架进行入库操作}ii++;

}

fileReader.Close();//关闭流

file.Close();//关闭流//删除文件

System.IO.File.Delete(filePath +fileName);if (ii ==sheet.LastRowNum)

{

Response.Write("");

}else{

Response.Write("");

}

}

}catch(Exception d)

{

}

}

}

}

}