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