This is a migrated thread and some comments may be shown as answers.

Is it possible to Bind Spreadsheet to IEnumerable<MyClass>

3 Answers 157 Views

Spreadsheet

This is a migrated thread and some comments may be shown as answers.

William asked on 29 Mar 2016, 10:14 PM

Is it possible to bind the Spreadsheet to IEnumerable<MyClass> where the property names would be the columns of the sheet and each item of the IEnumerable object would be a row in the sheet?

public class MyClass
{
public int Id { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
}

var myObject = new List<MyClass>()
{
new MyClass() {Id = 1,FirstName = "Lucas",LastName = "Green"},
new MyClass() {Id = 2,FirstName = "Eva",LastName = "Black"},
new MyClass() {Id = 3,FirstName = "Miroslava",LastName = "Brown"},
};

Output:
Id FirstName LastName
1 Lukas Green
2 Eva Black
3 Miroslava Brown

Is it possible to Bind Spreadsheet to IEnumerable<MyClass>

3 Answers, 1 is accepted