// DataManager => GridProperties
// SearchFilter
// dataManager.Search[0].Fields =>
// dataManager.Search[0].Key =>
// dataManager.Search[0].Operator =>
// WhereFilter FilteredColumn
// dataManager.Where[0].Field => gridProperties.FilterSettings.FilteredColumns[0].Field
// dataManager.Where[0].Operator => gridProperties.FilterSettings.FilteredColumns[0].Operator
// dataManager.Where[0].predicates => gridProperties.FilterSettings.FilteredColumns[0].Predicate
// dataManager.Where[0].value => gridProperties.FilterSettings.FilteredColumns[0].Value
// Sort SortedColumn
// dataManager.Sorted[0].Name => gridProperties.SortSettings.SortedColumns[0].Field
// dataManager.Sorted[0].Direction => gridProperties.SortSettings.SortedColumns[0].Direction
public static void ExportToExcel(string gridModel, IEnumerable data, string fileName, string theme)
{
GridProperties gridProperties = ModelToObject(gridModel);
ExcelExport export = new ExcelExport();
export.Export(gridProperties, data, fileName, ExcelVersion.Excel2013, false, false, theme);
}
public void ExportToExcel(string GridModel)
{
ExcelExport exp = new ExcelExport();
var DataSource = new NorthwindDataContext().OrdersViews.Take(100).ToList();
GridProperties obj = ConvertGridObject(GridModel);
exp.Export(obj, DataSource, "Export.xlsx", ExcelVersion.Excel2010, false, false, "flat-saffron");
}
private void ButtonExcel_ClickEvent(object arg1, EventArgs arg2)
{
using (var waitingForm = new LoadingForm())
{
var excelExporter = new ExcelExport();
excelExporter.Export(DVValues);
}
}
protected void TreeGridControlExporting_ServerExcelExporting(object sender, Syncfusion.JavaScript.Web.TreeGridEventArgs e)
{
ExcelExport exp = new ExcelExport();
IWorkbook workbook = exp.Export(this.TreeGridControlExporting.Model, (IEnumerable)this.TreeGridControlExporting.DataSource, new TreeGridExportSettings()
{
Theme = ExportTheme.FlatLime
}, true, "Planning Phase");
workbook = exp.Export(this.TreeGridControlDesign.Model, (IEnumerable)this.TreeGridControlDesign.DataSource, new TreeGridExportSettings()
{
Theme = ExportTheme.FlatLime
}, workbook, true, "Design Phase");
exp.Export(this.TreeGridControlImplementation.Model, (IEnumerable)this.TreeGridControlImplementation.DataSource, "ExcelExport.xlsx", ExcelVersion.Excel2010, new TreeGridExportSettings()
{
Theme = ExportTheme.FlatLime
}, workbook, false, "Implementation Phase");
}
protected void GanttControlExporting_ServerExcelExporting(object sender, Syncfusion.JavaScript.Web.GanttEventArgs e)
{
ExcelExport exp = new ExcelExport();
IWorkbook document = exp.Export(this.GanttControlExporting.Model, (IEnumerable)this.GanttControlExporting.DataSource, new GanttExportSettings()
{
Theme = ExportTheme.FlatLime
}, true, "Planning Phase");
document = exp.Export(this.GanttControlDesign.Model, (IEnumerable)this.GanttControlDesign.DataSource, new GanttExportSettings()
{
Theme = ExportTheme.FlatLime
}, "Export", document, true, "Design Phase");
exp.Export(this.GanttControlImplementation.Model, (IEnumerable)this.GanttControlImplementation.DataSource, new GanttExportSettings()
{
Theme = ExportTheme.FlatLime
}, "Export.xlsx", document, false, "Implementation Phase");
}
public void ExcelExport()
{
string gridModel = HttpContext.Current.Request.Params["GridModel"];
GridProperties gridProperty = ConvertGridObject(gridModel);
ExcelExport exp = new ExcelExport();
IEnumerable <Order> result = db.Orders.ToList();
exp.Export(gridProperty, result, "Export.xlsx", ExcelVersion.Excel2010, false, false, "flat-saffron");
}
public void ColumnTemplateExportToExcel(string GridModel)
{
ExcelExport exp = new ExcelExport();
var DataSource = new NorthwindDataContext().EmployeeViews.Take(8).ToList();
GridProperties obj = ConvertGridObject3(GridModel);
obj.ExcelColumnTemplateInfo = ExceltemplateInfo;
exp.Export(obj, DataSource, "Export.xlsx", ExcelVersion.Excel2010, false, true, "flat-saffron");
}
public void ExcelAction(string GridModel)
{
ExcelExport exp = new ExcelExport();
messageListVM = new List <ChatMessageViewModel>();
messageList = db.ChatMessages.ToList();
appUserList = db.AppUserModels.ToList();
groupList = db.GroupModels.ToList();
ChatMessageViewModel chatMessage = new ChatMessageViewModel();
foreach (ChatMessage u in messageList)
{
chatItem = new ChatMessageViewModel();
user = appUserList.Find(x => x.ID == u.UserId);
group = groupList.Find(x => x.ID == u.GroupId);
chatItem.Id = u.ChatId;
chatItem.Date = u.TimeStamp.ToShortDateString();
chatItem.Time = u.TimeStamp.ToLongTimeString();
chatItem.Name = u.Name;
chatItem.Message = u.Message;
chatItem.isFlagged = u.isFlagged;
if (user != null)
{
chatItem.UserName = user.Name;
}
else
{
chatItem.UserName = u.Name;
}
if (group != null)
{
chatItem.GroupName = group.GroupName;
}
else
{
chatItem.GroupName = "**deleted**";
}
messageListVM.Add(chatItem);
}
var DataSource = messageListVM.ToList();
GridProperties obj = (GridProperties)Syncfusion.JavaScript.Utils.DeserializeToModel(typeof(GridProperties), GridModel);
exp.Export(obj, DataSource, "Export.xlsx", ExcelVersion.Excel2010, false, false, "flat-saffron");
}
public void ExportToExcel(string GridModel)
{
ExcelExport exp = new ExcelExport();
var DataSource = TempData["ExportData"];
TempData["ExportData"] = DataSource;
GridProperties obj = (GridProperties)Syncfusion.JavaScript.Utils.DeserializeToModel(typeof(GridProperties), GridModel);
exp.Export(obj, DataSource, "Export.xlsx", ExcelVersion.Excel2010, false, false, "flat-saffron");
}
public void TestMethod1()
{
TestDataGenerator tg = new TestDataGenerator();
tg.createCatsClassesGroups();
Race race = tg.Model.GetRace(0);
tg.createRaceParticipant(cat: tg.findCat('M'), cla: tg.findClass("2M (2010)"), points: 1.0); // 1
tg.createRaceParticipant(cat: tg.findCat('M'), cla: tg.findClass("2M (2010)"), points: 2.0);
tg.createRaceParticipant(cat: tg.findCat('M'), cla: tg.findClass("2M (2010)"), points: 3.0);
tg.createRaceParticipant(cat: tg.findCat('W'), cla: tg.findClass("2W (2010)"), points: 1.5); // 4
tg.createRaceParticipant(cat: tg.findCat('W'), cla: tg.findClass("2W (2010)"), points: 2.5);
tg.createRaceParticipant(cat: tg.findCat('W'), cla: tg.findClass("2W (2010)"), points: 3.5); // 6
RaceRun rr1 = race.GetRun(0);
RaceRun rr2 = race.GetRun(1);
rr1.SetStartFinishTime(race.GetParticipant(1), new TimeSpan(8, 0, 0), new TimeSpan(8, 1, 0));
rr2.SetRunTime(race.GetParticipant(1), new TimeSpan(0, 0, 2, 0, 123));
rr1.SetRunTime(race.GetParticipant(2), new TimeSpan(0, 1, 1));
rr1.SetResultCode(race.GetParticipant(3), RunResult.EResultCode.NiZ);
Export export = new Export(tg.Model.GetRace(0));
DataSet ds = export.ExportToDataSet();
Assert.AreEqual("Name 1", ds.Tables[0].Rows[0]["Name"]);
Assert.AreEqual("Name 2", ds.Tables[0].Rows[1]["Name"]);
Assert.AreEqual("Name 3", ds.Tables[0].Rows[2]["Name"]);
Assert.AreEqual("Name 4", ds.Tables[0].Rows[3]["Name"]);
Assert.AreEqual("Name 5", ds.Tables[0].Rows[4]["Name"]);
Assert.AreEqual("Name 6", ds.Tables[0].Rows[5]["Name"]);
Assert.AreEqual("Firstname 1", ds.Tables[0].Rows[0]["Firstname"]);
Assert.AreEqual(1.0, ds.Tables[0].Rows[0]["Points"]);
Assert.AreEqual(new TimeSpan(0, 1, 0), ds.Tables[0].Rows[0]["Runtime_1"]);
Assert.AreEqual("Normal", ds.Tables[0].Rows[0]["Resultcode_1"]);
Assert.AreEqual(new TimeSpan(0, 0, 2, 0, 120), ds.Tables[0].Rows[0]["Runtime_2"]);
Assert.AreEqual("Normal", ds.Tables[0].Rows[0]["Resultcode_2"]);
Assert.AreEqual("NiZ", ds.Tables[0].Rows[2]["Resultcode_1"]);
var excelExport = new ExcelExport();
excelExport.Export(@"c:\trash\test.xlsx", ds);
var csvExport = new CsvExport();
csvExport.Export(@"c:\trash\test.csv", ds, true);
var tsvExport = new TsvExport();
tsvExport.Export(@"c:\trash\test.txt", ds, true);
}
public void ExcelEmpleado(string GridModel)
{
ExcelExport exp = new ExcelExport();
var DataSource = context.Empleados.ToList();
GridProperties obj = (GridProperties)Syncfusion.JavaScript.Utils.DeserializeToModel(typeof(GridProperties), GridModel);
obj.Columns[5].DataSource = context.Departamentos.ToList();
obj.Columns[12].DataSource = context.Sexo.ToList();
obj.Columns[13].DataSource = context.EstadoCivil.ToList();
exp.Export(obj, DataSource, "Empleados.xlsx", Syncfusion.XlsIO.ExcelVersion.Excel2010, false, false, "default-theme");
}
protected void TreeGridControlDefault_ServerExcelExporting(object sender, Syncfusion.JavaScript.Web.TreeGridEventArgs e)
{
ExcelExport exp = new ExcelExport();
TreeGridExportSettings settings = new TreeGridExportSettings();
settings.Theme = ExportTheme.FlatLime;
exp.Export(TreeGridControlDefault.Model, (IEnumerable)TreeGridControlDefault.DataSource, "Export.xlsx", ExcelVersion.Excel2010, new TreeGridExportSettings()
{
Theme = ExportTheme.BootstrapTheme
});
}
public void ExportToExcel(string TreeGridModel)
{
ExcelExport exp = new ExcelExport();
var DataSource = this.GetEditingDataSource();
TreeGridProperties obj = ConvertTreeGridObject(TreeGridModel);
exp.Export(obj, DataSource, "Export.xlsx", ExcelVersion.Excel2010, new TreeGridExportSettings()
{
Theme = ExportTheme.FlatSaffron
});
}
public void ExportToExcelAlbum(string GridModel)
{
ExcelExport exp = new ExcelExport();
var DataSource = context.Albums.ToList();
//GridProperties obj = (GridProperties)Syncfusion.JavaScript.Utils.DeserializeToModel(typeof(GridProperties), GridModel);
GridProperties obj = ConvertGridObject(GridModel);
obj.Columns[2].DataSource = context.Artistas.ToList();
obj.Columns[3].DataSource = context.Generoes.ToList();
exp.Export(obj, DataSource, "ExcelAlbum.xlsx", Syncfusion.XlsIO.ExcelVersion.Excel2010, false, false, "default-theme");
}
protected void ExportToExcel(string gridModel, IEnumerable data, string theme, string fileName)
{
GridProperties gridProperties = SyncfusionGrid.ModelToObject(gridModel);
ExcelExport export = new ExcelExport();
IWorkbook excel = export.Export(gridProperties, data, fileName, ExcelVersion.Excel2013, false, false, theme, true);
excel.ActiveSheet.DeleteRow(1, 1);
excel.SaveAs(fileName, ExcelSaveType.SaveAsXLS, System.Web.HttpContext.Current.Response, ExcelDownloadType.Open);
//excel.SaveAs(fileName, ExcelSaveType.SaveAsXLS, Controller.Response, ExcelDownloadType.Open);
}
protected void GanttControlExporting_ServerExcelExporting(object sender, Syncfusion.JavaScript.Web.GanttEventArgs e)
{
ExcelExport exp = new ExcelExport();
GanttExportSettings settings = new GanttExportSettings();
settings.Theme = ExportTheme.FlatLime;
exp.Export(this.GanttControlExporting.Model, (IEnumerable)this.GanttControlExporting.DataSource, "Export.xlsx", ExcelVersion.Excel2010, new GanttExportSettings()
{
Theme = ExportTheme.FlatLime
});
}
public ActionResult ExportToExcel(string GridModel)
{
ExcelExport exp = new ExcelExport();
var DataSource = _context.Orders.Take(100).ToList();
GridProperties gridProp = ConvertGridObject(GridModel);
GridExcelExport excelExp = new GridExcelExport();
excelExp.FileName = "Export.xlsx"; excelExp.Excelversion = ExcelVersion.Excel2010;
excelExp.Theme = "flat-saffron";
return(exp.Export(gridProp, DataSource, excelExp));
}
protected void EmployeesGrid_ServerExcelExporting(object sender, Syncfusion.JavaScript.Web.GridEventArgs e)
{
ExcelExport exp = new ExcelExport();
GridProperties obj = ConvertGridObject(e.Arguments["model"].ToString());
GridExcelExport exp1 = new GridExcelExport()
{
IsTemplateColumnIncluded = true, IsHideColumnIncude = false, Theme = "flat-lime", FileName = "Export.xlsx"
};
exp.Export(obj, (IEnumerable)EmployeesGrid.DataSource, exp1);
}
public void ExportToExcel(string GanttModel)
{
ExcelExport exp = new ExcelExport();
var DataSource = this.GetEditingDataSource();
GanttProperties obj = ConvertGanttObject(GanttModel);
exp.Export(obj, DataSource, "GanttExport.xlsx", ExcelVersion.Excel2010, new GanttExportSettings()
{
Theme = ExportTheme.FlatSaffron
});
}
public void ExportToExcel(string TreeGridModel)
{
ExcelExport exp = new ExcelExport();
var DataSource = this.GetLQASData();
TreeGridProperties obj = ConvertTreeGridObject(TreeGridModel);
obj.ServerExcelQueryCellInfo = queryCellDelegate;
exp.Export(obj, DataSource, "IntraCampaign.xlsx", ExcelVersion.Excel2010, new TreeGridExportSettings()
{
Theme = ExportTheme.None
});
}
public void TestExportMiddleGroupResults()
{
string Path = @"E:\Epam\.Net_EpamTraining\6";
StatisticSession ss = new StatisticSession();
List <object[]> obj = ss.GetMiddleGroupResults();
bool actual = ExcelExport.Export(obj, Path, "Middle_groups_results");
bool expected = true;
Assert.AreEqual(actual, expected);
}
public void ConditionalExcel(string GanttModel)
{
ExcelExport exp = new ExcelExport();
var DataSource = GetExportDataSource();
GanttProperties obj = ConvertToGanttObject(GanttModel);
obj.ServerExcelQueryCellInfo = queryExcelCellDelegate;
exp.Export(obj, DataSource, "GanttExport.xlsx", ExcelVersion.Excel2010, new GanttExportSettings()
{
Theme = ExportTheme.FlatSaffron
});
}
public void ExportToExcel(string TreeGridModel)
{
ExcelExport exp = new ExcelExport();
var DataSource = this.GetLQASData();
TreeGridProperties obj = ConvertTreeGridObject(TreeGridModel);
obj.ServerExcelQueryCellInfo = queryCellDelegate;
exp.Export(obj, DataSource, "Provincial_coverage.xlsx", ExcelVersion.Excel2013, new TreeGridExportSettings()
{
Theme = ExportTheme.FlatAzure
});
}
protected void courseGrid_ServerExcelExporting(object sender, Syncfusion.JavaScript.Web.GridEventArgs e)
{
try
{
ExcelExport exp = new ExcelExport();
exp.Export(courseGrid.Model, (IEnumerable)courseGrid.DataSource, "Export.xlsx", ExcelVersion.Excel2010, true, true, "flat-lime");
}
catch (Exception ex)
{
MessageBox.swalModal(this.Page, "error", "en:internal error[" + ex.Message.Replace("'", "") + "]", "");
}
}
public void ExportHierarchyToExcel(string GridModel)
{
ExcelExport exp = new ExcelExport();
var DataSource = new NorthwindDataContext().EmployeeViews.ToList();
GridProperties obj = ConvertGridObject(GridModel);
obj.ChildGrid.DataSource = new NorthwindDataContext().OrdersViews.Take(100).ToList();
GridExcelExport expo = new GridExcelExport();
expo.IncludeChildGrid = true;
exp.Export(obj, DataSource, expo);
}
public void TestExport()
{
var customers = ExcelImport.Import <CustomerTest>(@"C:\Users\Administrator\Desktop\客户导入.xlsx");
var bytes = ExcelExport.Export(customers, @"C:\Users\Administrator\Desktop\客户导出模板.xlsx", "客户导出", 1, new List <int>()
{
6
});
using (var fs = new FileStream(@"C:\Users\Administrator\Desktop\客户导出.xlsx", FileMode.OpenOrCreate, FileAccess.Write))
{
fs.Write(bytes, 0, bytes.Length);
}
}
private void BtnExportXlsx_Click(object sender, RoutedEventArgs e)
{
exportToTextFile
("Microsoft Excel (.xlsx)|*.xslx",
".xlsx",
(Race race, string filePath, bool utf8) =>
{
Export exp = new Export(race);
ExcelExport csvExp = new ExcelExport();
csvExp.Export(filePath, exp.ExportToDataSet());
}
);
}
public ActionResult ExportAsExcel()
{
List <AppointData> scheduleAppointments = (List <AppointData>)JsonConvert.DeserializeObject(Request.Form["ScheduleAppointment"], typeof(List <AppointData>));
for (int a = 0, len = scheduleAppointments.Count; a < len; a++)
{
scheduleAppointments[a].StartTime = Convert.ToDateTime(scheduleAppointments[a].StartTime).ToString();
scheduleAppointments[a].EndTime = Convert.ToDateTime(scheduleAppointments[a].EndTime).ToString();
}
ExcelExport xlExport = new ExcelExport();
return(xlExport.Export(scheduleAppointments));
}
public void TestGetYearsDinamicSubjectsMarks()
{
string Path = @"E:\Epam\.Net_EpamTraining\6";
StatisticSession ss = new StatisticSession();
List <object[]> obj = ss.GetYearsDinamicSubjectsMarks();
bool actual = ExcelExport.Export(obj, Path,
"_Task7__Middle_Subject_marks_for_years");
bool expected = true;
Assert.AreEqual(actual, expected);
}
protected void Schedule1_ServerExportExcel(object sender, ScheduleEventArgs e)
{
List <AppointmentData> scheduleAppointments = (List <AppointmentData>)JsonConvert.DeserializeObject(e.Arguments["ScheduleAppointment"].ToString(), typeof(List <AppointmentData>));
for (int a = 0, len = scheduleAppointments.Count; a < len; a++)
{
scheduleAppointments[a].StartTime = Convert.ToDateTime(scheduleAppointments[a].StartTime).ToString();
scheduleAppointments[a].EndTime = Convert.ToDateTime(scheduleAppointments[a].EndTime).ToString();
}
ExcelExport xlExport = new ExcelExport();
xlExport.Export(scheduleAppointments);
}
