上传excel在页面中显示

Question

上传Excel至页面如何做？

Answer 1

    protected void Button1_Click(object sender, EventArgs e)
    {
        if (FileUpload1.PostedFile.ContentLength > 0)
        {
            string dataSource = FileUpload1.PostedFile.FileName;
            string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
               "Data Source=" + dataSource + ";" +
               "Extended Properties=Excel 8.0;";
            OleDbConnection conn = new OleDbConnection(strConn);
            OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn);
            DataSet myDataSet = new DataSet();
            myCommand.Fill(myDataSet);
            GridView1.DataSource = myDataSet.Tables[0];
            GridView1.DataBind();
        }
    }