public void ExcelConverter_Can_Read_Multiple_Sheets_From_A_Workbook()
{
var excelConverter = new ExcelConverter();
var result1 = excelConverter.Read <MockExcelRow3>(this.xlsxTestResource);
var result2 = excelConverter.Read <MockExcelRow4>(this.xlsxTestResource);
Assert.Equal(10, result1.Count());
Assert.Equal(4, result2.Count());
}
public void ExcelConverter_Can_Read_A_Single_Sheet_From_A_Workbook()
{
var excelConverter = new ExcelConverter();
var result = excelConverter.Read <MockExcelRow3>(this.xlsxTestResource);
Assert.Equal(10, result.Count());
}
static void Main(string[] args)
{
var excelConverter = new ExcelConverter();
//Read Example
var people = excelConverter.Read <Person>("..\\..\\..\\people.xlsx");
foreach (var person in people)
{
Console.WriteLine($"{person.EyeColour} : {person.Age} : {person.Height}");
}
//Write Example
var peopleToWrite = new List <Person>();
for (int i = 0; i < 10; i++)
{
peopleToWrite.Add(new Person
{
EyeColour = Guid.NewGuid().ToString(),
Age = new Random().Next(1, 100),
Height = new Random().Next(100, 200)
});
}
excelConverter.Write(peopleToWrite, "..\\..\\..\\newPeople.xlsx");
}
public void ExcelConverter_Can_Read_A_Single_Row_From_A_Sheet()
{
var excelConverter = new ExcelConverter();
List <MockExcelRow5> rows = (List <MockExcelRow5>)excelConverter.Read <MockExcelRow5>(xlsxTestResource);
Assert.NotEmpty(rows);
rows[0].GetType().GetProperties().ToList().ForEach(property =>
{
Assert.NotNull(property.GetValue(rows[0]));
});
}
public void ExcelConverter_Can_Read_Multiple_Rows_From_A_Sheet()
{
var excelConverter = new ExcelConverter();
List <List <IExcelRow> > sheets = new List <List <IExcelRow> >();
sheets.Add(excelConverter.Read <MockExcelRow3>(this.xlsxTestResource).ToList <IExcelRow>());
sheets.Add(excelConverter.Read <MockExcelRow4>(this.xlsxTestResource).ToList <IExcelRow>());
sheets.Add(excelConverter.Read <MockExcelRow5>(this.xlsxTestResource).ToList <IExcelRow>());
sheets.ForEach(sheet =>
{
Assert.NotEmpty(sheet);
sheet.ForEach(row =>
{
row.GetType().GetProperties().ToList().ForEach(property =>
{
Assert.NotNull(property.GetValue(row));
});
});
});
}
private ICollection <Person> convertToPersonCollection(Stream inputStream)
{
var excelConverter = new ExcelConverter();
var rows = excelConverter.Read <PersonRow>(inputStream);
if (rows == null)
{
throw new FileFormatException(
"There was an error reading the file. " +
"Make sure to check the property names in the row model match the column names in the spreadhseet.");
}
return(convertRowsToPeople(rows));
}