/// <summary>
        /// Получить таблицу цен международных перевозок
        /// </summary>
        /// <returns></returns>
        internal List <TruckRate> GetTruckRateInternational()
        {
            List <TruckRate> ListRate   = new List <TruckRate>();
            Worksheet        sheetRoute = Globals.ThisWorkbook.Sheets["Rate Inetrnational"];
            ListObject       rateTable  = sheetRoute.ListObjects["TableRateInternational"];

            foreach (ListRow row in rateTable.ListRows)
            {
                string valTonnage = row.Range[1, rateTable.ListColumns["tonnage, t"].Index].Text;
                double tonnage    = double.TryParse(valTonnage, out double t) ? t : 0;

                string valCity = row.Range[1, rateTable.ListColumns["City"].Index].Text;
                valCity = valCity.Trim();

                string valCompany = row.Range[1, rateTable.ListColumns["Company"].Index].Text;
                valCompany = valCompany.Trim();

                if (tonnage > 0 && !string.IsNullOrWhiteSpace(valCity))
                {
                    string  strPrice = row.Range[1, rateTable.ListColumns["vehicle"].Index].Value.ToString();
                    decimal price    = decimal.TryParse(strPrice, out decimal pf) ? pf : 0;

                    strPrice = row.Range[1, rateTable.ListColumns["add.point"].Index].Value.ToString();
                    decimal priceAdd = decimal.TryParse(strPrice, out decimal pa) ? pa : 0;

                    TruckRate rate = new TruckRate()
                    {
                        City            = valCity,
                        Company         = valCompany,
                        PriceFirstPoint = price,
                        PriceAddPoint   = priceAdd,
                        PlaceShipment   = row.Range[1, 1].Text,
                        Tonnage         = tonnage
                    };

                    ListRate.Add(rate);
                }
            }
            return(ListRate);
        }
        /// <summary>
        /// Получить вес список цен перевозчиков в формате списка
        /// </summary>
        /// <returns></returns>
        private static List <TruckRate> GetTruckRateList()
        {
            List <TruckRate> ListRate = new List <TruckRate>();

            foreach (ListRow row in RateTable.ListRows)
            {
                string valTonnage = row.Range[1, RateTable.ListColumns["tonnage, t"].Index].Text;
                double tonnage    = double.TryParse(valTonnage, out double t) ? t : 0;

                string valCity = row.Range[1, RateTable.ListColumns["City"].Index].Text;
                valCity = valCity.Trim();

                string valCompany = row.Range[1, RateTable.ListColumns["Company"].Index].Text;
                valCompany = valCompany.Trim();


                if (tonnage > 0 && !string.IsNullOrWhiteSpace(valCity))
                {
                    string  strPrice   = row.Range[1, RateTable.ListColumns["vehicle"].Index].Value.ToString();
                    decimal priceFirst = decimal.TryParse(strPrice, out decimal pf) ? pf : 0;
                    strPrice = row.Range[1, RateTable.ListColumns["add.point"].Index].Value.ToString();
                    decimal   priceAdd = decimal.TryParse(strPrice, out decimal pa) ? pa : 0;
                    TruckRate rate     = new TruckRate()
                    {
                        City            = valCity,
                        Company         = valCompany,
                        PriceFirstPoint = priceFirst,
                        PriceAddPoint   = priceAdd,
                        PlaceShipment   = row.Range[1, 1].Text,
                        PlaceDelivery   = row.Range[1, 2].Text,
                        Tonnage         = tonnage
                    };

                    ListRate.Add(rate);
                }
            }
            return(ListRate);
        }