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