protected void btnUpload_Click(object sender, EventArgs e)
{
bool flag = false;
StringBuilder sb = new StringBuilder();
if (this.FileUpload1.FileName == "")
{
sb.Append("請選擇excel文件!!" + "\r\n");
}
else
{
string filefullpath = this.FileUpload1.PostedFile.FileName;
string filename = filefullpath.Substring(filefullpath.LastIndexOf("\\") + 1);
string type = filename.Substring(filename.LastIndexOf(".") + 1).ToLower();
if (type == "xls")
{
string sJudgeIfExit = Server.MapPath("..\\Upload\\") + filename;
if (System.IO.Directory.Exists(sJudgeIfExit))
{
sb.Append("文件名重復!!" + "\r\n");
}
else
{
this.FileUpload1.PostedFile.SaveAs(sJudgeIfExit);
Session["OTCTable"] = CreateDataSource(sJudgeIfExit).Tables[0];
sb.Append("加載ExcelOK!" + "\r\n");
flag = true;
}
}
else
{
sb.Append("請選擇excel文件操作!" + "\r\n");
}
}
}
private DataSet CreateDataSource(string filepath)
{
DataSet myds = new DataSet();
string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath + "; Extended Properties=Excel 8.0;";
OleDbConnection olecon = new OleDbConnection(strCon);
OleDbDataAdapter myda = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strCon);
myda.Fill(myds, "excel");
return myds;
}