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_Write_A_MultiSheet_Workbook() { var excelConverter = new ExcelConverter(); var rows = new List <IExcelRow>(); for (int i = 0; i < 100; i++) { var mockRow = new MockExcelRow(); mockRow.SheetName = $"Sheet{i}"; rows.Add(mockRow); } using (var result = new MemoryStream()) { excelConverter.Write(rows, result); Assert.True(result.Length > 0); } }
protected void convertToExcel(IEnumerable <IExcelRow> rows, Stream outputStream) { var excelConverter = new ExcelConverter(); excelConverter.Write(rows, outputStream); }