我导入的时候XCEL里面的工作表名必须是SHEET，怎么修改才可以动态获取，即有些工作表名是按时间来定的，怎么样才能动态获取，不然每次导入都要改XCEL里面的名称

public DataSet ExecleDs(string filenameurl, string table, string excelTableName)
{
excelTableName = string.IsNullOrWhiteSpace(excelTableName) ? "Sheet1" : excelTableName；
string strConn = "Provider = Microsoft.Jet.OLEDB.4.0;" + "data source=" + filenameurl + ";Extended Properties='Excel 8.0; HDR=yes; IMEX=1'";
string strcom = "select *from [" + excelTableName + "$]";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
DataSet ds = new DataSet();
OleDbDataAdapter odda = new OleDbDataAdapter(strcom, conn);
odda.Fill(ds, table);
conn.Close();
return ds;
}

各位大神来帮帮忙

顶一个