static void Main(string[] args)
{
var data = new List <IEnumerable <object> >();
using (var db = new SampleDataContext())
{
data.Add(db.Users.OrderBy(x => x.Name).ToList());
data.Add(db.Orders.OrderBy(x => x.Customer).ThenByDescending(x => x.Date).ToList());
}
var bytes = Spreadsheet.Create(data);
File.WriteAllBytes("MySpreadsheet.xlsx", bytes);
}
static void Main(string[] args)
{
var data = new List <IEnumerable <object> >();
using (var db = new SampleDataContext())
{
data.Add(db.Users.OrderBy(x => x.Name).ToList());
foreach (var grouping in db.Orders.OrderBy(x => x.Date).GroupBy(x => x.Date.Month))
{
data.Add(grouping.ToList());
}
}
var bytes = Spreadsheet.Create(data);
File.WriteAllBytes("MySpreadsheet.xlsx", bytes);
}
static void Main(string[] args)
{
var data = new List<IEnumerable<object>>();
using (var db = new SampleDataContext())
{
data.Add(db.Users.OrderBy(x => x.Name).ToList());
foreach(var grouping in db.Orders.OrderBy(x => x.Date).GroupBy(x => x.Date.Month))
{
data.Add(grouping.ToList());
}
}
var bytes = Spreadsheet.Create(data);
File.WriteAllBytes("MySpreadsheet.xlsx", bytes);
}