String path = @"G:\新建文件夹\AW-还原原始MAP图\AW1680B_U94361-15_20190109145048.xls";
string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";" +
"Extended Properties='Excel 8.0;HDR=YES;IMEX=1'";
//把第一行也作为数据行,那我们可以给连接字符串添加一个HDR=No属性
//把所有列都做为字符串来读取,只要添加属性IMEX=1即可
//Microsoft.ACE.OLEDB.12.0
//Microsoft.Jet.OLEDB.4.0 这个可能会报错
//学习网址如下:
//https://blog.csdn.net/jiajiayouba/article/details/7531707
//https://www.cnblogs.com/baby0814/p/5545292.html
DataSet ds = new DataSet();
// OleDbDataAdapter oada = new OleDbDataAdapter("select * from [sheet1(表名)$]", strConn);
OleDbDataAdapter oada = new OleDbDataAdapter("select * from [_00_STDF01$]", strConn);
oada.Fill(ds);
showResult(ds.Tables[0].Rows.Count);