一个查询excel记录的ip并ping的小程序

因为现场的设备ip配置都是固定的，有时候想测试网络怎么样要挨个ping特麻烦，就弄了个方法来ping，文件路径暂时都是写死的

.net core 的 一个控制台程序

static void Main(string[] args)
        {
            Console.WriteLine("Hello World!");
            DataSet ds =  ToDataTable("F:\***\***\IP地址分配.xlsx");
            DataTable dt = ds.Tables[0];
            string butrong = string.Empty;
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                string ip = dt.Rows[i][3].ToString().Trim().Replace("。", ".");
                if (!string.IsNullOrEmpty(ip))
                {
                    string rtn = (PingIp(ip) ? "trun" : "false");
                    if (rtn == "false")
                    {
                        butrong += dt.Rows[i][2].ToString();
                        butrong += ip;
                        butrong += "||";
                    }
                    Console.WriteLine("pingIP" + ip+" : "+ rtn);
                }
                
            }
            Console.WriteLine("不通的ip有："+ butrong);
        }
        /// <summary>
        /// ping ip,测试能否ping通
        /// </summary>
        /// <param name="strIP">IP地址</param>
        /// <returns></returns>
        private static bool PingIp(string strIP)
        {
            bool bRet = false;
            try
            {
                Ping pingSend = new Ping();
                PingReply reply = pingSend.Send(strIP, 1000);
                if (reply.Status == IPStatus.Success)
                    bRet = true;
            }
            catch (Exception)
            {
                bRet = false;
            }
            return bRet;
        }



        /// <summary>  
        /// 读取Excel文件到DataSet中  
        /// </summary>  
        /// <param name="filePath">文件路径</param>  
        /// <returns></returns>  
        public static DataSet ToDataTable(string filePath)
        {
            string connStr = "";
            string fileType = System.IO.Path.GetExtension("F:\***\***\IP地址分配.xlsx");
            if (string.IsNullOrEmpty(fileType)) return null;

            if (fileType == ".xls")
                connStr = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + filePath + ";" + ";Extended Properties="Excel 8.0;HDR=YES;IMEX=1"";
            else
                connStr = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + filePath + ";" + ";Extended Properties="Excel 12.0;HDR=YES;IMEX=1"";
            string sql_F = "Select * FROM [{0}]";

            OleDbConnection conn = null;
            OleDbDataAdapter da = null;
            DataTable dtSheetName = null;

            DataSet ds = new DataSet();
            try
            {
                // 初始化连接，并打开  
                conn = new OleDbConnection(connStr);
                conn.Open();

                // 获取数据源的表定义元数据                         
                string SheetName = "";
                dtSheetName = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });

                // 初始化适配器  
                da = new OleDbDataAdapter();
                for (int i = 0; i < dtSheetName.Rows.Count; i++)
                {
                    SheetName = (string)dtSheetName.Rows[i]["TABLE_NAME"];

                    if (SheetName.Contains("$") && !SheetName.Replace("'", "").EndsWith("$"))
                    {
                        continue;
                    }

                    da.SelectCommand = new OleDbCommand(String.Format(sql_F, SheetName), conn);
                    DataSet dsItem = new DataSet();
                    da.Fill(dsItem,i.ToString());//这里找个第二个参数还没弄明白是干嘛用的，网上抄的

                    ds.Tables.Add(dsItem.Tables[0].Copy());
                }
            }
            catch (Exception ex)
            {
            }
            finally
            {
                // 关闭连接  
                if (conn.State == ConnectionState.Open)
                {
                    conn.Close();
                    da.Dispose();
                    conn.Dispose();
                }
            }
            return ds;
        }