/// <summary>
/// Adds a list of customers and header row to a spreadsheet
/// </summary>
private static void AddCustomersSheet(SpreadsheetDocument spreadsheetDocument)
{
var worksheet = spreadsheetDocument.AddWorksheet("Customers");
// Add HeaderRow
worksheet.AddRow(data: typeof(Customer).GetProperties(), styleIndex: 2);
// Add DataRows
foreach (var customer in GenerateCustomers())
{
var array = new object[]
{
customer.Name,
customer.Address,
customer.City,
customer.State,
customer.ZipCode,
customer.DateEntered,
};
worksheet.AddRow(array, 1);
}
}
