ASP.NET c# 导入<em>excel</em>文件如何实现，求代码-excel .net

C#导入Excel中的数据，可以编写个引7a64e59b9ee7ad94337用，程序如下：
openFileDialog1.Filter = "Execl files (*.xls)|*.xls";
openFileDialog1.FilterIndex = 0;
openFileDialog1.RestoreDirectory = true;
openFileDialog1.Title = "导入文件保存路径";
openFileDialog1.FileName = null;
openFileDialog1.ShowDialog();
string FileName = openFileDialog1.FileName;
if (FileName != "")
{
String connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FileName + "; Extended Properties=Excel 8.0;";
String sql = "SELECT * FROM [Sheet1$]"; OleDbDataAdapter da = new OleDbDataAdapter(sql, connStr);
DataSet ds = new DataSet();
da.Fill(ds);
foreach (DataRow dr in ds.Tables[0].Rows)
{

string[] total = dr[0].ToString().Split('-');
string server = total[0];
string ah = total[1].Substring(0, 1);
string strSql = "select * from JMFServername_list where Servername_realm=@server and AH=@ah";
SqlConnection sqlconn = new SqlConnection(strsql);
sqlconn.Open();
SqlCommand sqlcmd = new SqlCommand(strSql, sqlconn);
sqlcmd.Parameters.AddWithValue("@server", server);
sqlcmd.Parameters.AddWithValue("@ah", ah);
SqlDataReader dtr = sqlcmd.ExecuteReader();
if (dtr.Read())
{
continue;
}
string sqlQuery = "insert into JMFServername_list(Servername_realm,AH)values(@server,@AH)"; sqlcmd = new SqlCommand(sqlQuery, sqlconn);
sqlcmd.Parameters.AddWithValue("@server",server);
sqlcmd.Parameters.AddWithValue("@AH", ah);
sqlcmd.ExecuteNonQuery();
}

myDGV.DataSource = ds.Tables[0];
}

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
using System.Data.Sql;
using System.Data.SqlClient;
using Microsoft.Office.Interop;
using Microsoft.Office.Interop.Excel;
using System.Reflection;

namespace ExcelConvertor
{
public partial class Form1 : Form
{

public Form1()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{
this.openFileDialog1.Multiselect = true;
this.openFileDialog1.Filter = "EXCEL文件(*.xls)|*.xls";
if (this.openFileDialog1.ShowDialog() == DialogResult.OK)
{
this.textBox1.Text = openFileDialog1.FileName;
filename = openFileDialog1.FileName;
}
}

private void button2_Click(object sender, EventArgs e)
{
System.Data.DataTable dt = new System.Data.DataTable();
ExcelToDT(this.textBox1.Text, ref dt);
ExcelConvertor(dt);

}
public static string filename;
public static bool ExcelConvertor(System.Data.DataTable dt)
{

string s = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() +DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString();
string savefilepath = filename.Substring(0, filename.LastIndexOf('\\') + 1) +s+ ".dat";
string djbh = dt.Rows[2][0].ToString(); //单据编号7a686964616fe4b893e5b19e337
string lybm = dt.Rows[2][2].ToString(); //领用部门
string flbm = dt.Rows[2][3].ToString(); //发料部门
string lyrq = "";//领用日期
if (dt.Rows[2][4].ToString() != "")
{
if (dt.Rows[2][4].ToString().Contains("-"))
{
lyrq = dt.Rows[2][4].ToString();//领用日期
}
else
{
lyrq = DateTime.FromOADate(Convert.ToInt32(dt.Rows[2][4].ToString())).ToString("d"); //领用日期

}
}
else
{

lyrq = DateTime.Now.ToLongDateString();
}

string year = DateTime.Parse(lyrq).Year.ToString();
string month = DateTime.Parse(lyrq).Month.ToString();
string xmgd = dt.Rows[4][6].ToString();//项目/工段
string cpdm = dt.Rows[4][0].ToString();//产品代码
string cpmc = dt.Rows[4][2].ToString();//产品名称
string pcs = dt.Rows[4][4].ToString();//排产计划数

// int rowcount = dt.Rows.Count;

//生成Excel文件
Microsoft.Office.Interop.Excel.Application app =
new Microsoft.Office.Interop.Excel.ApplicationClass();
try
{
app.Visible = false;
Workbook wBook = app.Workbooks.Add(true);
Worksheet wSheet = wBook.Worksheets[1] as Worksheet;
if (dt.Rows.Count > 0)
{
int row = 0;
row = dt.Rows.Count; //总行数
int col = dt.Columns.Count; //总列数，可能没用

for (int i = 1; i <= dt.Rows.Count; i++) //
{
if (dt.Rows[i + 5][0].ToString() == "")
{
break;
}
wSheet.Cells[i, 1] = "21";
wSheet.Cells[i, 2] = "19";
wSheet.Cells[i, 3] = year;
wSheet.Cells[i, 4] = month;
wSheet.Cells[i, 5] = djbh;
wSheet.Cells[i, 6] = "";
wSheet.Cells[i, 7] = "吉林瑞宝生产领用";
wSheet.Cells[i, 8] = lyrq;
wSheet.Cells[i, 9] = "R10";//制单人
wSheet.Cells[i, 10] = "";
wSheet.Cells[i, 11] = "";
wSheet.Cells[i, 12] = "5001-97R";
wSheet.Cells[i, 13] = "1";
wSheet.Cells[i, 14] = "RMB";
wSheet.Cells[i, 15] = xmgd;//项目工段
wSheet.Cells[i, 16] = cpdm;
wSheet.Cells[i, 17] = "2008-04-07";
wSheet.Cells[i, 18] = "2008-04-07";
wSheet.Cells[i, 19] = "";
wSheet.Cells[i, 20] = "";
wSheet.Cells[i, 21] = "0";
wSheet.Cells[i, 22] = "0";
wSheet.Cells[i, 23] = "";
wSheet.Cells[i, 24] = ",";
wSheet.Cells[i, 25] = "";
wSheet.Cells[i, 26] = ",";
wSheet.Cells[i, 27] = "";
wSheet.Cells[i, 28] = "";

wSheet.Cells[i, 29] = i.ToString();//行号
wSheet.Cells[i, 30] = dt.Rows[i+ 5][0].ToString();
wSheet.Cells[i, 31] = "";
wSheet.Cells[i, 32] = "'"+dt.Rows[i + 5][11].ToString(); //货位
wSheet.Cells[i, 33] = dt.Rows[i + 5][2].ToString();//计量单位
wSheet.Cells[i, 34] = dt.Rows[i + 5][8].ToString();//实发数量
wSheet.Cells[i, 35] = dt.Rows[i + 5][9].ToString();//计划单价
wSheet.Cells[i, 36] = "";
wSheet.Cells[i, 37] = "100";
wSheet.Cells[i, 38] = double.Parse(dt.Rows[i + 5][8].ToString()) * double.Parse(dt.Rows[i + 5][9].ToString());
wSheet.Cells[i, 39] = double.Parse(dt.Rows[i + 5][8].ToString()) * double.Parse(dt.Rows[i + 5][9].ToString());
wSheet.Cells[i, 40] = "";
wSheet.Cells[i, 41] = "0";
wSheet.Cells[i, 42] = "0";
wSheet.Cells[i, 43] = "";
wSheet.Cells[i, 44] = "";
wSheet.Cells[i, 45] = "";
wSheet.Cells[i, 46] = "0";
wSheet.Cells[i, 47] = "";
wSheet.Cells[i, 48] = "";
wSheet.Cells[i, 49] = "";
wSheet.Cells[i, 50] = "";
wSheet.Cells[i, 51] = "";
wSheet.Cells[i, 52] = "";
wSheet.Cells[i, 53] = "";
wSheet.Cells[i, 54] = "";
wSheet.Cells[i, 55] = "0";
wSheet.Cells[i, 56] = double.Parse(dt.Rows[i + 5][8].ToString()) * double.Parse(dt.Rows[i + 5][9].ToString());
wSheet.Cells[i, 57] = "0";
wSheet.Cells[i, 58] = "0";
wSheet.Cells[i, 59] = "0";
wSheet.Cells[i, 60] = double.Parse(dt.Rows[i + 5][8].ToString()) * double.Parse(dt.Rows[i + 5][9].ToString());
wSheet.Cells[i, 61] = "";
wSheet.Cells[i, 62] = "";
wSheet.Cells[i, 63] = "1003";
wSheet.Cells[i, 64] = "R027";
wSheet.Cells[i, 65] = "";
wSheet.Cells[i, 66] = "";
wSheet.Cells[i, 67] = "";
wSheet.Cells[i, 68] = "0";
wSheet.Cells[i, 69] = "0";
wSheet.Cells[i, 70] = "";
wSheet.Cells[i, 71] = "";
wSheet.Cells[i, 72] = "0";
wSheet.Cells[i, 73] = "0";
wSheet.Cells[i, 74] = "";
wSheet.Cells[i, 75] = "";
wSheet.Cells[i, 76] = "0001-05";
wSheet.Cells[i, 77] = "2";
wSheet.Cells[i, 78] = "";
wSheet.Cells[i, 79] = "1";
wSheet.Cells[i, 80] = "";
wSheet.Cells[i, 81] = "";
wSheet.Cells[i, 82] = "0";
wSheet.Cells[i, 83] = "";
wSheet.Cells[i, 84] = "";
wSheet.Cells[i, 85] = "";
wSheet.Cells[i, 86] = "";
wSheet.Cells[i, 87] = "";
wSheet.Cells[i, 88] = "";
wSheet.Cells[i, 89] = "";
wSheet.Cells[i, 90] = "";
wSheet.Cells[i, 91] = "";
wSheet.Cells[i, 92] = "";
wSheet.Cells[i, 93] = "";
wSheet.Cells[i, 94] = "";
wSheet.Cells[i, 95] = "";
wSheet.Cells[i, 96] = "";
wSheet.Cells[i, 97] = "";
wSheet.Cells[i, 98] = "";
wSheet.Cells[i, 99] = "";
wSheet.Cells[i, 100] = "";
wSheet.Cells[i, 101] = "";
wSheet.Cells[i, 102] = "";
wSheet.Cells[i, 103] = "";
wSheet.Cells[i, 104] = "";
wSheet.Cells[i, 105] = "";
wSheet.Cells[i, 106] = "";
wSheet.Cells[i, 107] = "";
wSheet.Cells[i, 108] = "";
wSheet.Cells[i, 109] = "";
wSheet.Cells[i, 110] = "";
wSheet.Cells[i, 111] = "";
wSheet.Cells[i, 112] = "";
wSheet.Cells[i, 113] = "";
wSheet.Cells[i, 114] = "";
wSheet.Cells[i, 115] = "";
wSheet.Cells[i, 116] = "";
wSheet.Cells[i, 117] = "";

}
}
wSheet.SaveAs(savefilepath, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);

wBook.Close(false, Missing.Value, Missing.Value);//关闭
wSheet = null;
wBook = null;
app.Quit();
app = null;

//int size = excelTable.Columns.Count;
//for (int i = 0; i < size; i++)
//{
// wSheet.Cells[1, 1 + i] = excelTable.Columns[i].ColumnName;
//}
//设置禁止弹出保存和覆盖的询问提示框
//app.DisplayAlerts = false;
//app.AlertBeforeOverwriting = false;
////保存工作簿
//wBook.Save();
////保存excel文件

//app.Save("C:\a.xls");
//app.SaveWorkspace("C:\a.xls");
MessageBox.Show("转换成功！");
return true;
}
catch (Exception err)
{
MessageBox.Show("导出Excel出错！错误原因：" + err.Message, "提示信息",
MessageBoxButtons.OK, MessageBoxIcon.Information);
return false;
}
finally
{
}

}

//public static bool SaveDataTableToExcel(System.Data.DataTable excelTable, string filePath)
//{
// Microsoft.Office.Interop.Excel.Application app =
// new Microsoft.Office.Interop.Excel.ApplicationClass();

//}

public static System.Data.DataTable ExcelToDT(string filename, ref System.Data.DataTable dt)
{ //先将EXCEL导入到数据库,一:先把EXCEL导入dateView,二:然后将dateView里的数据导入到数据库里面
//EXCEL 的连接串
string sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + filename + ";" +
"Extended Properties='Excel 8.0;IMEX=1'";
OleDbConnection objConn = new OleDbConnection(sConnectionString);
objConn.Open();
System.Data.DataTable resultdt = objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[4] { null, null, null, "TABLE" });
objConn.Close();
try
{

foreach (DataRow dr in resultdt.Rows)
{
//这里的删掉一些找不到的sheet,类似sheet1_
if (dr["Table_Name"].ToString().IndexOf('_') < 0)
{
OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM [" + dr["Table_Name"].ToString() + "]", objConn);
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();
objAdapter1.SelectCommand = objCmdSelect;
DataSet objDataset1 = new DataSet();

//建立EXCEL的连接
objConn.Open();
objAdapter1.Fill(objDataset1);
objConn.Close();

// DataGrid1.DataSource = objDataset1.Tables[0].DefaultView; //测试代码,用来测试是否能读出EXCEL上面的数据
// DataGrid1.DataBind();
//这里的tmpdt就是读到的当前sheet的dt了
System.Data.DataTable tmpdt = objDataset1.Tables[0];
dt = tmpdt;
string fileName = "";
fileName = filename.Substring(filename.LastIndexOf('\\') + 1);

}
break;

}
return dt;
}
catch (Exception e)
{
if (objConn.State == ConnectionState.Open)
{
objConn.Close();
}
string s = e.Message;
Console.Write("转换操作出错");
return null;

}
}

}
}
这样的问题很多了
你需要一个放一个fileupload控件 用来上传excel ，还需要在项目里建一个文件夹e68a84e8a2ade79fa5e98193331用来存放你要上传的excel 。因为系统总是先把文件传到服务器上再进行操作，而不是对每个人的桌面excel直接操作。
using System.Data.SqlClient;
using System.Data.OleDb; //　 要加这两句
public DataSet ExecleDs(string filenameurl, string table) // 这个函数就是将上传的excel读入dataset
{
string strConn = "Provider=Microsoft.Jet.OleDb.4.0;" + "data source=" + filenameurl + ";Extended Properties='Excel 8.0; HDR=YES; IMEX=1'"; // 这里excel03 如要该成07版再问我或者百度
string strcom = "select *from [Sheet1$]";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
DataSet ds = new DataSet();
OleDbDataAdapter odda = new OleDbDataAdapter(strcom, conn);
odda.Fill(ds, table);
return ds;

}

protected void Button4_Click(object sender, EventArgs e) // 你的那个确定按钮
{
SqlConnection con = new SqlConnection();
con.ConnectionString = "server='CWJMXT-14\\SQLEXPRESS';database='E-test';uid='sa';pwd=‘..'" ; // 你自己的数据库连接
if (FileUpload1.HasFile == false)//HasFile用来检查FileUpload是否有指定文件
{
Response.Write("<script>alert('请您选择Excel文件')</script> ");
return;//当无文件时,返回
}
string IsXls = System.IO.Path.GetExtension(FileUpload1.FileName).ToString().ToLower();//System.IO.Path.GetExtension获得文件的扩展名
if (IsXls != ".xls")
{
Response.Write("<script>alert('只可以选择Excel文件')</script>");
return;//当选择的不是Excel文件时,返回
}

con.Open();
string filename = FileUpload1.FileName; //获取Execle文件名 DateTime日期函数
// Label2.Text = filename;
string savePath = Server.MapPath(("~\\upfiles\\") + filename);//Server.MapPath 获得虚拟服务器相对路径
FileUpload1.SaveAs(savePath); //SaveAs 将上传的文件内容保存在服务器上
DataSet ds = ExecleDs(savePath, filename); //调用自定义方法
DataRow[] dr = ds.Tables[0].Select(); //定义一个DataRow数组
int rowsnum = ds.Tables[0].Rows.Count;
if (rowsnum == 0)
{
Response.Write("<script>alert('Excel表为空表,无数据!')</script>"); //当Excel表为空时,对用户进行提示
}
else
{
for (int i = 0; i < dr.Length; i++)
{
//string pininputdate = dr[i]["].ToString();//日期 excel列名【名称不能变,否则就会出错】

string insertstr = "insert into item1(试题组别,试题类型,试题题目,选项A,选项B,选项C,选项D,正确答案,随机或必出)values('" + dr[i][0].ToString() + "','" + dr[i][1].ToString() + "','" + dr[i][2].ToString() + "','" + dr[i][3].ToString() + "','" + dr[i][4].ToString() + "','" + dr[i][5].ToString() + "','" + dr[i][6].ToString() + "','" + dr[i][7].ToString() + "','" + dr[i][8].ToString() + "')"; //这里就是具体怎么样一行一行将dataset中的数据导入sql的 你也可以加一些其他判断什么的。 SqlCommand cmd = new SqlCommand(insertstr, con);
try
{
cmd.ExecuteNonQuery();
}
catch (MembershipCreateUserException ex) //捕捉异常
{
Response.Write("<script>alert('导入内容:" + ex.Message + "')</script>");
}

}
Response.Write("<script>alert('Excle表导入成功!');location='itemmaintain.aspx'</script>");
}
con.Close();
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;
using System.Data.OleDb;
using System.Data;
using System.Web.Services;

public partial class admin_Att_ExcelImporting : System.Web.UI.Page
{
static string puth = "";
protected void Page_Load(object sender, EventArgs e)
{
}

[WebMethod]
public static List<string> getExcelSheetNames()
{
OleDbConnection conn = null;
try
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + puth + ";" + "Extended Properties=Excel 8.0;";
conn = new OleDbConnection(strConn);
conn.Open();
DataTable dt = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
List<string> strli = new List<string>();
foreach (DataRow dr in dt.Rows)
{
strli.Add((String)dr["TABLE_NAME"]);
}
conn.Close();
return strli;
}
catch (Exception)
{
if (conn != null)
conn.Close();
return null;
}
}
public DataSet ExcelToDS(string sheetName)
{
OleDbConnection conn = null;
try
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + puth + ";" + "Extended Properties=Excel 8.0;";
conn = new OleDbConnection(strConn);
conn.Open();
string strExcel = "";
OleDbDataAdapter myCommand = null;
DataSet ds = null;
strExcel = "select * from ["+sheetName+"]";
myCommand = new OleDbDataAdapter(strExcel, strConn);
ds = new DataSet();
myCommand.Fill(ds, "sheetName");
return ds;
}
catch (Exception ex)
{
if (conn != null)
{
conn.Close();
}
Tool.LogWrite.WriteLog(ex);
return null;
}
}
protected void AsyncFileUpload1_UploadedComplete(object sender, AjaxControlToolkit.AsyncFileUploadEventArgs e)
{
if (System.IO.Path.GetExtension(e.FileName) == ".xls")
{
AjaxControlToolkit.AsyncFileUpload au = sender as AjaxControlToolkit.AsyncFileUpload;
string nowputh = Server.MapPath(".");
DirectoryInfo dir = new DirectoryInfo(nowputh);
string upputh = dir.Parent.FullName + "\\TemporaryExcel\\";
if (!Directory.Exists(upputh))
Directory.CreateDirectory(upputh);
Random random = new Random();
string randomNum = random.Next(100000, 999999).ToString();
upputh += randomNum.ToString();
upputh += System.IO.Path.GetExtension(e.FileName);
puth = upputh;
if (au != null && au.HasFile)
au.SaveAs(upputh);
}
else
{

}
}
[WebMethod]
public static string Emp_ExcelImporting(string sheet,string type)
{
int rowcount = 0;
int rowerr = 0;
string message = "";
//TR.BLL.Org_PositionBll orgpbll = new TR.BLL.Org_PositionBll();
//TR.BLL.Org_OrganizationBll orgbll=new TR.BLL.Org_OrganizationBll();

TR.BLL.Emp_EmployeesBasicBLL empbll=new TR.BLL.Emp_EmployeesBasicBLL();
TR.BLL.Sys_TypeBll sysbll=new TR.BLL.Sys_TypeBll();
try
{
admin_Att_ExcelImporting ff = new admin_Att_ExcelImporting();
DataSet ds = ff.ExcelToDS(sheet);
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
if (type=="2")
{
foreach (DataRow r in dt.Rows)
{
try
{
rowcount++;
int empid = empbll.GetEmpIdByJobNumber(r[0].ToString());
int systypeId = sysbll.GetTypeIdByTypeName(r[2].ToString());
if (empid == 0)
{
message += "插入第" + rowcount + "条数据时，社番号不正确，插入失败，已跳过！</br>";
rowerr++;
}
else if (systypeId == 0)
{
message += "插入第" + rowcount + "条数据时，检测到'" + r[2] + "'请假类型不存在，插入失败，已跳过！</br>";
rowerr++;
}
else
{
Object obj = Tool.SQLHelper.ExecuteScalar(CommandType.Text, "select id from Att_Leave where empId=" + empid + " and typeId="+systypeId+" and DATEDIFF(day,'" + DateTime.Now.ToString("yyyy-MM-dd") + "',addTime)=0", null);
string str = "";
if (obj==null)
{
str = "INSERT INTO [dbo].[Att_Leave]([empId],[typeId],[leaveTime1],[leaveTime2],[days],[leaveReason],[isEnd],[added],[status])VALUES(" + empid + " ," + systypeId + ",'" + r[3] + "','" + r[4] + "'," + r[5] + ",'" + r[6] + "',1,'" + ff.Session["User_Nickname"] + "',1)";
}
else
{
str = "update Att_Leave set typeId=" + systypeId + ",leaveTime1='"+r[3]+"',leaveTime2='"+r[4]+"',days="+r[5]+",leaveReason='"+r[6]+"',isEnd=1,added='"+ff.Session["User_Nickname"]+"',status=1 where id="+Convert.ToInt32(obj);
}
Tool.SQLHelper.ExecuteNonQuery(CommandType.Text, str, null);
}

}
catch (Exception)
{
message += "插入第" + rowcount + "条数据时发生错误（可能是数据格式存在问题），已跳过！</br>";
rowerr++;
}
}
}
else
{
foreach (DataRow r in dt.Rows)
{
try
{
rowcount++;
int empid = empbll.GetEmpIdByJobNumber(r[0].ToString());
int systypeId = sysbll.GetTypeIdByTypeName(r[2].ToString());
if (empid == 0)
{
message += "插入第" + rowcount + "条数据时，社番号不正确，插入失败，已跳过！</br>";
rowerr++;
}
else if (systypeId == 0)
{
message += "插入第" + rowcount + "条数据时，检测到'" + r[2] + "'加班类型不存在，插入失败，已跳过！</br>";
rowerr++;
}
else
{
Object obj =Tool.SQLHelper.ExecuteScalar(CommandType.Text,"select id from Att_Overtime where empId="+empid+" and typeId="+systypeId+" and datediff(day,'"+DateTime.Now+"',addTimes)=0",null);
string str = "";
if (obj == null)
{
str = "INSERT INTO [dbo].[Att_Overtime]([empId],[typeId],[overtime],[addTime],[added],[status]) VALUES (" + empid + "," + systypeId + "," + r[3] + ",'" + r[4] + "','" + ff.Session["User_Nickname"] + "',1)";
}
else
{
str = "update Att_Overtime set [empId]=" + empid + ",[typeId]=" + systypeId + ",[overtime]='" + r[3] + "',[addTime]='" + r[4] + "',[added]='" + ff.Session["User_Nickname"] + "',[status]=1 where id="+Convert.ToInt32(obj);
}
Tool.SQLHelper.ExecuteNonQuery(CommandType.Text, str, null);
}

}
catch (Exception)
{
message += "插入第" + rowcount + "条数据时发生错误（可能是数据格式存在问题），已跳过！</br>";
rowerr++;
}
}
}
if (rowerr == 0)
{
return "执行e799bee5baa6e997aee7ad94e78988e69d83336全部成功！共执行" + rowcount + "行，成功" + rowcount + "行</br>";
}
else
{
return (message + "执行完成！共执行" + rowcount + "行，成功" + (rowcount - rowerr) + "行，失败" + rowerr + "行</br>");
}
}
else
{
return "Excel数据为空！</br>";
}
}
catch (Exception ex)
{
return "执行过程中发生异常！"+ex.Message+"</br>";
}

}
}