示例#1
0
        public PlayerList Read(string filePath)
        {
            playerList = new PlayerList();

            package = new ExcelPackage(new FileInfo(filePath));
            sheet1  = package.Workbook.Worksheets[1];

            for (int i = 2; i <= sheet1.Dimension.End.Row; i++)
            {
                string firstName  = (sheet1.Cells[i, 1].Value ?? string.Empty).ToString();
                string secondName = (sheet1.Cells[i, 2].Value ?? string.Empty).ToString();
                string position   = (sheet1.Cells[i, 3].Value ?? string.Empty).ToString();
                string team       = (sheet1.Cells[i, 4].Value ?? string.Empty).ToString();

                PlayerListPlayer player = new PlayerListPlayer(firstName, secondName, position, team);
                playerList.Players.Add(player);
            }

            return(playerList);
        }
        public PlayerList Read(string filePath)
        {
            playerList = new PlayerList();

            using (var reader = new StreamReader(filePath))
            {
                while (!reader.EndOfStream)
                {
                    var line   = reader.ReadLine();
                    var values = line.Split(',');

                    string firstName  = values[0].Trim();
                    string secondName = values[1].Trim();
                    string position   = values[2].Trim();
                    string team       = values[3].Trim();

                    PlayerListPlayer player = new PlayerListPlayer(firstName, secondName, position, team);
                    playerList.Players.Add(player);
                }
            }

            return(playerList);
        }