private static void WriteHeaders(ExcelWorksheet excelWorksheet, IEnumerable <PropertyInfo> properties, DataWriterModel dataWriterModel)
{
foreach (var propertyInfo in properties)
{
excelWorksheet.Cells[dataWriterModel.CurrentRow, dataWriterModel.CurrentColumn].Value = propertyInfo.Name;
dataWriterModel.NextColumn();
}
dataWriterModel.NextRow();
dataWriterModel.RestartColumns();
}
private static void WriteRecords(IEnumerable records, ExcelWorksheet excelWorksheet, IEnumerable <PropertyInfo> properties, DataWriterModel dataWriterModel)
{
foreach (var record in records)
{
foreach (var propertyInfo in properties)
{
excelWorksheet.Cells[dataWriterModel.CurrentRow, dataWriterModel.CurrentColumn].Value = propertyInfo.GetValue(record, null);
dataWriterModel.NextColumn();
}
dataWriterModel.NextRow();
dataWriterModel.RestartColumns();
}
}
