CopyCode The 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 ();
}