static void AnonymousExportData()
{
var filename = Guid.NewGuid().ToString() + ".xlsx";
System.IO.File.WriteAllBytes(filename, Properties.Resources.Empty);
Random r = new Random();
var items = Enumerable.Range(0, 1000).Select(i => new
{
Id = i,
Name = "Product " + i.ToString(),
Category = r.Next(1, 10),
IsValid = true
}).ToArray();
using (var context = new ExcelContext(filename))
{
var item = items[0];
var operate = context.Database.Manager.CreateTable(item.GetType(),
DbName.NameOnly("Sheet1$"));
context.Executor.Execute(operate);
context.Set(item, "[Sheet1$]").AddRange(items);
context.Executor.Execute();
}
}
static void AnonymousImportData()
{
using (var context = new ExcelContext("sample.xls"))
{
var item = new { Id = 1, Name = "P", IsValid = false };
var data = context.Set(item, "Products").ToArray();
}
}
