Copy codeThe Code is as follows:
If (this. FileUpload1.PostedFile! = Null)
{
String filename = this. FileUpload1.FileName. ToString ();
String path = @ Server. MapPath ("../File/") + filename;
This. FileUpload1.PostedFile. SaveAs (path );
// Read the Excle File Uploaded by the user
String conn = "Provider = Microsoft. Jet. OLEDB.4.0; Data Source = '" + path + "'; Extended Properties = Excel 8.0 ";
OleDbConnection olecon = new OleDbConnection (conn );
Olecon. Open ();
// Note the table name. After the Excel file is opened, the Excle name on the lowest page is displayed,
// The default value is $ 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 ();
}