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