[httppost]
public void import()
{
//获取文件
httppostedfilebase filebase = request.files[“file”];
if(filebase==null)
{
response.write(“”);
}
//转数据流
stream stream = filebase.inputstream;
iworkbook workbook = null;
if (path.getextension(filebase.filename).tolower().equals(“.xls”))
{
workbook = new hssfworkbook(stream);
}
//获取sheet
isheet sheet = workbook.getsheetat(0);
//获取头
irow row = sheet.getrow(0);
//定义datatable
datatable dt = new datatable();
foreach (icell item in row.cells)
{
//循环添加表头
dt.columns.add(item.stringcellvalue);
}
for (int i = 0; i <= sheet.lastrownum; i++)
{
datarow dr = dt.newrow();
for (int j = 0; j < sheet.getrow(i).cells.count; j++)
{
celltype celltype = sheet.getrow(i).cells[j].celltype;
int index = sheet.getrow(i).cells[j].columnindex;
switch (celltype)
{
case celltype.numeric:dr[index]=sheet.getrow(i).cells[j].numericcellvalue;
break;
case celltype.string:
dr[index] = sheet.getrow(i).cells[j].stringcellvalue;
break;
case celltype.boolean:
dr[index] = sheet.getrow(i).cells[j].booleancellvalue;
break;
}
}
dt.rows.add(dr);
}
//sql拼接
try
{
dt.columns.removeat(0);
foreach (datarow item in dt.rows)
{
string sql = $”inserrt into mess values(“;
foreach (object it in item.itemarray)
{
sql += $”‘{it}’,”;
}
sql = sql.trimend(‘,’);
sql += “)”;
db.executenonquery(sql);
}
}
catch (exception)
{
throw;
}
}
//前台
<form action=”/default/import” method=”post” enctype=”multipart/form-data”>
<input type=”file” name=”file” id=”file”>
<input type=”submit” name=”name” class=”btn btn-success btn-sm” value=”导入”>
</form>
