原来by sheetname获取
string strConn;
DataSet objMyDataSet = new DataSet();
//读上传文件内容
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;";
strConn = strConn + "Data Source=" + filePath;
objMyOleDbConnection.ConnectionString = strConn;
objMyOleDbConnection.Open();
OleDbDataAdapter objMyDataAdapter = new OleDbDataAdapter("SELECT * FROM [" + sheetName + "$]", objMyOleDbConnection);
objMyDataAdapter.Fill(objMyDataSet, sheetName);
DataTable dtblSheet = objMyDataSet.Tables[sheetName];
// 移除名称为空的数据列
for (int j = 0; j < dtblSheet.Columns.Count; j++)
{
dtblSheet.Columns[j].ColumnName