有没有一种方法可以通过读取csv文件来填充Xamarin.Forms中的ObservableCollection

Question

我下面有一个Student类，我在ViewModel类中使用ObservableCollection在ListView中显示学生。有没有我可以从csv/电子表格中阅读，让学生填写ObservableCollection？

public class Student
{
public string Firstname { get; set; }
public string Surname { get; set; }
public string Module { get; set; }
public Project(string Firstname, string Surname, string Module)
{
this.Firstname = Firstname;
this.Surname = Surname;
this.Module = Module;
}
public class ProjectListViewModel
{
public ObservableCollection<Student> Students { get; set; }
public ProjectListViewModel()
{
Students = new ObservableCollection<Project>();
Students.Add(new Student("Ben", "Ledley", "Maths"));
Students.Add(new Student("John", "Alex", "English"));
Students.Add(new Student("Sam", "Craig", "Biology"));
}

}

Answer 1

是的，您可以通过从NuGet Package安装CsvHelper来使用CsvHelper读取csv数据。

您可以创建一个.csv文件并将其放入Xamarin.Forms项目中。存在读取.csv文件数据的类似示例。您可以参考以下代码。

例如，test.csv的内容如下：(将Build Action设置为Embedded resource。(:

ID,Name,Age
1,A,11
2,B,12
3,C,13
4,D,14
5,E,15

项目型号为Item.cs

public  class Item
{
public string ID { get; set; }
public string Name { get; set; }
public string Age { get; set; }
}

主页.xaml

<StackLayout>
<ListView  x:Name="mListView" HasUnevenRows="True">
<ListView.ItemTemplate>
<DataTemplate>
<ViewCell>
<StackLayout Orientation="Horizontal" HorizontalOptions="Fill" BackgroundColor="Olive">
<StackLayout Orientation="Vertical">
<Label Text = "{Binding Name}" FontSize="24" AbsoluteLayout.LayoutBounds="0.25, 0.25, 400, 40"/>
<Label Text = "{Binding Age}" AbsoluteLayout.LayoutBounds="50, 35, 200, 25"/>
</StackLayout>
</StackLayout>
</ViewCell>
</DataTemplate>
</ListView.ItemTemplate>
</ListView>
<Button Clicked="Button_Clicked" Text="Read data from CSV" />
</StackLayout>

MainPage.xaml.cs

public partial class MainPage : ContentPage
{
public ObservableCollection<Item> items { get; set; }
public MainPage()
{
InitializeComponent();
items = new ObservableCollection<Item>();
mListView.ItemsSource = items;
}
private void Button_Clicked(object sender, EventArgs e)
{
var assembly = Assembly.GetExecutingAssembly();
var resourceName = "ReadFromExcel.test.csv";
using (Stream stream = assembly.GetManifestResourceStream(resourceName))
using (StreamReader reader = new StreamReader(stream))
{
//string result = reader.ReadToEnd();
if (reader != null)
{
using (var csv = new CsvReader(reader, CultureInfo.CurrentCulture))
{
while (csv.Read())
{
items.Add(new Item
{
ID = csv.GetField<string>(0),
Name = csv.GetField<string>(1),
Age = csv.GetField<string>(2)
});
}
}
}
}
}
}

注意：点击按钮后，我们可以从.CSV文件中读取数据。