110,538
社区成员
发帖
与我相关
我的任务
分享
public static DataSet LoadDataFromExcel(string filePath, ref string message)
{
try
{
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties='Excel 8.0;HDR=False;IMEX=1'";
OleDbConnection OleConn = new OleDbConnection(strConn);
OleConn.Open();
String sql = "SELECT * FROM [Sheet1$]";//可是更改Sheet名称,比如sheet2,等等
OleDbDataAdapter OleDaExcel = new OleDbDataAdapter(sql, OleConn);
DataSet OleDsExcle = new DataSet();
OleDaExcel.Fill(OleDsExcle, "Sheet1");
OleConn.Close();
return OleDsExcle;
}
catch (Exception err)
{
message = err.Message;
//MessageBox.Show("数据绑定Excel失败!失败原因:" + err.Message, "提示信息",
// MessageBoxButtons.OK, MessageBoxIcon.Information);
return null;
}
}
int num=0;
string url = (@Server.MapPath("~/UploadFiles/") + filename).ToString();
this.FileUpload1.PostedFile.SaveAs(@Server.MapPath("~/UploadFiles/") + filename); //得到excel路径
string mystring = string.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + url + " ;Extended Properties='Excel 8.0;HDR=yes;IMEX=1'");
OleDbConnection cnnxls = new OleDbConnection(mystring);
OleDbDataAdapter myDa = new OleDbDataAdapter("select * from [Sheet1$] ", cnnxls);
DataSet ds = new DataSet();
myDa.Fill(ds);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
num ++ ;
if(num ==7)//如果是第七行数据就执行相应的代码,要是还想读取第八行,第九行...就把 等于 换成大于
{
userName = ds.Tables[0].Rows[i][0].ToString();//读取第一列数据
sid=ds.Tables[0].Rows[i][1].ToString();//读取第二列数据
....
}
else
{
continue;
}
}