Import Excel file to Gridview

[orked]

i tried to import excel file into gridview but the code made this exception (Failed to map this path''xmlTest.xml") i don't know why
my code:

public void fillGrid()
    {
        DataSet ds = new DataSet();
        ds.ReadXml(Server.MapPath("../xmlTest.xml"));
        GridView1.DataSource = ds;
        GridView1.DataBind();
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            fillGrid();
        }
    }
 
    protected void btImport_Click(object sender, EventArgs e)
    {
        string conn = ("Provider=Microsoft.Jet.OLEDB.4.0;" + ("Data Source=C:\\WebSqlEditor\\test.xls;" + "Extended Properties=Excel 8.0;"));  
        string SSQL = "SELECT name , dept, salary  from [sheet1$]";
        OleDbDataAdapter oleDA = new OleDbDataAdapter(SSQL, conn); 
        DataSet ds = new DataSet();
        oleDA.TableMappings.Add("Table","ExcelTest"); 
        oleDA.Fill(ds);
        GridView1.DataSource = ds.Tables[0].DefaultView; 
        GridView1.DataBind();
    }

what i can do?
thanks

[YonngTyler]

I suggest to use a*c# excel component Spire.XLS, I use it long time, quit good.
It*supports importing/exporting to XLS, XLSX, CSV and HTML files.
May help to you.