有关获取Excel的sheet名和获取excel数据的问题_spreadjs获得sheet页名字-CSDN博客

本文链接：https://blog.csdn.net/jame_peng/article/details/3050419

 
 using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        
        string fileName = "ToOwn_On.xls";
        string filePath = Server.MapPath("~/Excel/") + fileName;
        Excel.Application myExcel = new Excel.ApplicationClass();
        object oMissing = System.Reflection.Missing.Value;
        myExcel.Application.Workbooks.Open(filePath, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing);
        Excel.Workbook myBook = myExcel.Workbooks[1];
        Excel.Worksheet mySheet = (Excel.Worksheet)myBook.Worksheets[1];
        Response.Write(mySheet.Name);
        string strConnection = string.Format("Provider = Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;Data Source ={0}", filePath);
        OleDbConnection conn = new OleDbConnection(strConnection);
        OleDbCommand com = new OleDbCommand("SELECT * FROM [ExcuteResult$]", conn);
        OleDbDataAdapter da = new OleDbDataAdapter(com);
        DataSet ds = new DataSet();
        da.Fill(ds);
        GridView1.DataSource = ds.Tables[0].DefaultView;
        GridView1.DataBind(); 
    }
}
 