asp.net xls表格导入详细说明与代码

作者：袖梨 2022-06-25

在开发应用中xls文件导入到数据库教程是常用的，下面我们来看这款程序，有需要的朋友可以下载。

using system;
using system.configuration;
using system.data;
using system.web;
using system.web.security;
using system.web.ui;
using system.web.ui.htmlcontrols;
using system.web.ui.webcontrols;
using system.web.ui.webcontrols.webparts;
using system.io; public partial class _default : system.web.ui.page
{
protected void page_load(object sender, eventargs e)
{ } ///

/// 上传excel文件
///

/// 上传的控件名
///
private string uploadxls(system.web.ui.htmlcontrols.htmlinputfile inputfile)
{
string orifilename = string.empty;
string uploadfilepath = string.empty;
string modifyfilename = string.empty;
string fileext = "" ;//文件扩展名
int filesize = 0;//文件大小
try
{
if(inputfile.value != string.empty)
{
//得到文件的大小
filesize = inputfile.postedfile.contentlength;
if(filesize == 0 )
{
throw new exception("导入的excel文件大小为0，请检查是否正确！");
}
//得到扩展名
fileext = inputfile.value.substring(inputfile.value.lastindexof(".")+1);
if(fileext.tolower() != "xls")
{ throw new exception("你选择的文件格式不正确，只能导入excel文件！");
}
//路径
uploadfilepath = server.mappath("~/");
//新文件名
modifyfilename = system.guid.newguid().tostring();
modifyfilename += "."+inputfile.value.substring(inputfile.value.lastindexof(".")+1);
//判断是否有该目录
system.io.directoryinfo dir = new system.io.directoryinfo(uploadfilepath); if (!dir.exists)
{
dir.create();
}
orifilename = uploadfilepath+modifyfilename;
//如果存在,删除文件
if(file.exists(orifilename))
{
file.delete(orifilename);
}
// 上传文件
inputfile.postedfile.saveas(orifilename);
}
else
{
throw new exception("请选择要导入的excel文件!"); }
}
catch(exception ex)
{
throw ex;
}
return orifilename;
} protected void btnimport_click(object sender, system.eventargs e)
{ try
{
string strfilename = this.uploadxls(this.comfile);
string strconn = "provider=microsoft.jet.oledb.4.0;data source=" + strfilename + ";extended properties='excel 8.0;hdr=no;imex=1'";
oledbconnection conn = new oledbconnection(strconn);
oledbdataadapter mycommand = new oledbdataadapter("select * from [sheet1$]", strconn);
dataset mydataset = new dataset();
mycommand.fill(mydataset);
string str = "";
}
catch (exception ex)
{
throw ex;
}
finally
{
deletefile(strfilename);
}

} ///

/// 删除文件
///

/// 待删除的文件名
private void deletefile(string filename)
{
if (filename != string.empty && file.exists(filename))
{
file.delete(filename);
}
}
}