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:

Expand|Select|Wrap|Line Numbers

 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.

Import Excel file to Gridview

re: Import Excel file to Gridview

Similar topics

More