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);
}