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