表名
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("/") + "Stu2009-10-15.xls" + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'";
OleDbConnection objConn = new OleDbConnection(strConn);
List<string> SheetNameList = new List<string>();
objConn.Open();
DataTable dtExcelSchema = objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
string SheetName = "";
for (int i = 0; i < dtExcelSchema.Rows.Count; i++)
{
SheetName = dtExcelSchema.Rows[i]["TABLE_NAME"].ToString();//表名
SheetNameList.Add(SheetName);
}
GridView1.DataSource =SheetNameList;
GridView1.DataBind();
数据
SELECT * FROM [学生$]//就多了一个$
表头