/// <summary>
/// Creates an Excel Workbook from a DataSet
/// </summary>
/// <param name="sqlResults">The DataSet to populate a workbook with. The TableName of each DataTable will be the header and Tab name of each sheet.</param>
/// <param name="title">The Title of the workbook</param>
/// <returns></returns>
public static ExcelPackage CreateNewFile( DataSet sqlResults = null, string title = null )
{
var excel = new ExcelPackage();
excel.Workbook.Properties.Title = title;
excel.Workbook.Properties.Author = UserLoginService.GetCurrentUser()?.Person?.FullName ?? "Rock";
// Create the worksheet(s)
foreach ( DataTable data in sqlResults.Tables )
{
excel.AddWorksheet( data );
}
return excel;
}
