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