public ActionResult CsvExport(string gridModel)
{
GridExcelExport exp = new GridExcelExport();
Syncfusion.EJ2.Grids.Grid gridProperty = ConvertGridObject(gridModel);
return(exp.CsvExport <OrdersDetails>(gridProperty, OrdersDetails.GetRecords()));
}
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 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));
}
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 ActionResult HierarchyExportToExcel(string GridModel)
{
ExcelExport exp = new ExcelExport();
var DataSource = emp;
GridProperties gridProp = ConvertGridModel(GridModel);
gridProp.ChildGrid.DataSource = _context.Orders.Take(100).ToList();
GridExcelExport excelExp = new GridExcelExport();
excelExp.FileName = "Export.xlsx"; excelExp.Excelversion = ExcelVersion.Excel2010;
excelExp.Theme = "flat-saffron";
excelExp.IncludeChildGrid = true;
return(exp.Export(gridProp, DataSource, excelExp));
}
public ActionResult ExportToExcel(string GridModel)
{
ExcelExport exp = new ExcelExport();
var DataSource = _context.Clients
.Include(c => c.Country)
.Include(o => o.Occupation).Take(100).ToList();
GridProperties gridProp = ConvertGridObject(GridModel);
GridExcelExport excelExp = new GridExcelExport
{
FileName = "Export.xlsx",
Excelversion = ExcelVersion.Excel2010,
Theme = "flat-saffron"
};
return(exp.Export(gridProp, DataSource, excelExp));
}
protected void usersGrid_ServerExcelExporting(object sender, GridEventArgs e)
{
try
{
ExcelExport exp = new ExcelExport();
GridExcelExport excelExport = new GridExcelExport();
excelExport.FileName = "Export.xlsx";
excelExport.IsTemplateColumnIncluded = true;
excelExport.IsHideColumnIncude = true;
excelExport.Excelversion = ExcelVersion.Excel2010;
excelExport.Theme = "flat-lime";
exp.Export(LogsGrid.Model, (IEnumerable)LogsGrid.DataSource, excelExport);
}
catch (Exception ex)
{
MessageBox.swalModal(this.Page, "error", "en:internal error[" + ex.Message.Replace("'", "") + "]", "");
}
}
protected override void Invoke(object parameter)
{
if (parameter is SelectionChangedEventArgs)
{
SelectionChangedEventArgs eventArgs = parameter as SelectionChangedEventArgs;
ComboBox comboBox = eventArgs.OriginalSource as ComboBox;
ExportAsPivotTable = comboBox.SelectedIndex == 1;
}
else if (parameter is RoutedEventArgs)
{
try
{
RoutedEventArgs eventArgs = parameter as RoutedEventArgs;
Button exportButton = eventArgs.OriginalSource as Button;
SaveFileDialog savedialog = new SaveFileDialog();
savedialog.AddExtension = true;
savedialog.FileName = "Sample";
switch (exportButton.Content.ToString())
{
case "Export To Excel":
savedialog.DefaultExt = "xlsx";
savedialog.Filter = "Excel file (.xlsx)|*.xlsx";
if (savedialog.ShowDialog() == true)
{
GridExcelExport excelExport = new GridExcelExport(this.Target, Syncfusion.XlsIO.ExcelVersion.Excel2007);
excelExport.ExportMode = ExportAsPivotTable ? ExportModes.PivotTable : ExportModes.Cell;
excelExport.Export(savedialog.FileName);
MessageBox.Show("Excel sheet exported successfully!");
}
break;
case "Export To PDF":
savedialog.DefaultExt = "pdf";
savedialog.Filter = "Pdf file (.pdf)|*.pdf";
if (savedialog.ShowDialog() == true)
{
GridPdfExport pdfExport = new GridPdfExport(this.Target);
pdfExport.Export(savedialog.FileName);
MessageBox.Show("PDF document exported successfully!");
}
break;
case "Export To Word":
savedialog.DefaultExt = "Doc";
savedialog.Filter = "Word file (.Doc)|*.Doc";
if (savedialog.ShowDialog() == true)
{
GridWordExport wordExport = new GridWordExport(this.Target);
wordExport.Export(savedialog.FileName);
MessageBox.Show("Word document exported successfully!");
}
break;
case "Export To CSV":
savedialog.DefaultExt = "CSV";
savedialog.Filter = "Csv file (.csv)|*.csv";
if (savedialog.ShowDialog() == true)
{
GridCsvExport csvExport = new GridCsvExport(this.Target);
csvExport.Delimiter = ",";
csvExport.Export(savedialog.FileName);
MessageBox.Show("CSV document exported successfully!");
}
break;
}
}
catch (Exception ex)
{
MessageBox.Show("Error while exporting." + Environment.NewLine + "Exception Message: " + ex.Message, "Error on export", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
private void DoExport(object parm)
{
if (parm != null)
{
if (parm.ToString().Equals("Export to Excel"))
{
try
{
SaveFileDialog savedialog = new SaveFileDialog();
savedialog.AddExtension = true;
savedialog.FileName = "Sample";
savedialog.DefaultExt = "xls";
savedialog.Filter = "Excel file (.xls)|*.xls";
if (savedialog.ShowDialog() == true)
{
GridExcelExport gridExcelExport = new GridExcelExport(this.GridDataManager.PivotEngine, this.ExportGridStyleInfo, this.GridLayout, savedialog.DefaultExt, false);
gridExcelExport.Export(savedialog.FileName);
MessageBox.Show("Exported successfully!.");
}
}
catch (Exception ex)
{
MessageBox.Show("Error on Excel export.\nException Message: " + ex.Message + "\nStack Trace: " + ex.StackTrace, "Export error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
else if (parm.ToString().Equals("Export to Word"))
{
try
{
SaveFileDialog savedialog = new SaveFileDialog();
savedialog.AddExtension = true;
savedialog.FileName = "Sample";
savedialog.DefaultExt = "Doc";
savedialog.Filter = "Word file (.Doc)|*.Doc";
if (savedialog.ShowDialog() == true)
{
GridWordExport gridWordExport = new GridWordExport(this.GridDataManager.PivotEngine, this.GridLayout);
gridWordExport.Export(savedialog.FileName, this.ExportGridStyleInfo);
MessageBox.Show("Exported successfully!.");
}
}
catch (Exception ex)
{
MessageBox.Show("Error on Word export.\nException Message: " + ex.Message + "\nStack Trace: " + ex.StackTrace, "Export error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
else if (parm.ToString().Equals("Export to Pdf"))
{
try
{
SaveFileDialog savedialog = new SaveFileDialog();
savedialog.AddExtension = true;
savedialog.FileName = "Sample";
savedialog.DefaultExt = "pdf";
savedialog.Filter = "Pdf file (.pdf)|*.pdf";
if (savedialog.ShowDialog() == true)
{
GridPdfExport gridPdfExport = new GridPdfExport(this.GridDataManager.PivotEngine, this.ExportGridStyleInfo);
gridPdfExport.Export(savedialog.FileName);
MessageBox.Show("Exported successfully!.");
}
}
catch (Exception ex)
{
MessageBox.Show("Error on PDF export.\nException Message: " + ex.Message + "\nStack Trace: " + ex.StackTrace, "Export error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
else if (parm.ToString().Equals("Export to CSV"))
{
try
{
SaveFileDialog savedialog = new SaveFileDialog();
savedialog.AddExtension = true;
savedialog.FileName = "Sample";
savedialog.DefaultExt = "CSV";
savedialog.Filter = "Csv file (.csv)|*.csv";
if (savedialog.ShowDialog() == true)
{
GridCsvExport gridCsvExport = new GridCsvExport(this.GridDataManager.PivotEngine);
gridCsvExport.Export(savedialog.FileName);
MessageBox.Show("CSV document exported successfully!.");
}
}
catch (Exception ex)
{
MessageBox.Show("Error on CSV export.\nException Message: " + ex.Message + "\nStack Trace: " + ex.StackTrace, "Export error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
}
