|
|
if (this.FileUpload1.PostedFile != null)
{
string filename = this.FileUpload1.FileName.ToString();
string path = @Server.MapPath("../File/") + filename;
this.FileUpload1.PostedFile.SaveAs(path);
//讀取用戶上傳的Excle文件
string conn="Provider = Microsoft.Jet.OLEDB.4.0 ;Data Source ='"+path+"';Extended Properties=Excel 8.0";
OleDbConnection olecon = new OleDbConnection(conn);
olecon.Open();
//注意表名,打開(kāi)Excel文件后,最底部分頁(yè)的Excle名字,
//默認(rèn)是$Sheet1,$Sheet2,$Sheet3
string sql = "select * from [$Sheet1]";
OleDbDataAdapter oleda = new OleDbDataAdapter(sql,conn);
oleda.Fill(ds);
olecon.Close();
this.GridView1.DataSource = ds;
this.GridView1.DataBind();
string file_name = "20091126002.xml";
string xml_path = @Server.MapPath("../Reports/xml/") + file_name;
ds.WriteXml(xml_path);
ds.Dispose();
}
AspNet技術(shù)：asp.net下將Excel轉(zhuǎn)成XML檔的實(shí)現(xiàn)代碼，轉(zhuǎn)載需保留來(lái)源！
鄭重聲明：本文版權(quán)歸原作者所有，轉(zhuǎn)載文章僅為傳播更多信息之目的，如作者信息標(biāo)記有誤，請(qǐng)第一時(shí)間聯(lián)系我們修改或刪除，多謝。
