private static void OnExecuteExportToExcel(object sender, ExecutedRoutedEventArgs args) { var dataGrid = args.Source as SfDataGrid; EccelOptionsConverter ExcelOption = new EccelOptionsConverter(); if (dataGrid == null) { return; } try { //Setting the Exporting Options by craeting a instance for ExcelExportingOptions. var exportingOptions = args.Parameter as ExcelExportingOptions; exportingOptions.ExportingEventHandler = ExportingHandler; if (!ExcelOption.isCustomized) { exportingOptions.CellsExportingEventHandler = CellExportingHandler; } else { exportingOptions.CellsExportingEventHandler = CustomizeCellExportingHandler; } exportingOptions.ExportStackedHeaders = true; //Below code exports datagrid to excel and returns Excel Engine. var excelEngine = dataGrid.ExportToExcel(dataGrid.View, exportingOptions); var workBook = excelEngine.Excel.Workbooks[0]; //saving the workbook using savefiledialog. SaveFileDialog sfd = new SaveFileDialog { FilterIndex = 2, Filter = "Excel 97 to 2003 Files(*.xls)|*.xls|Excel 2007 to 2010 Files(*.xlsx)|*.xlsx", FileName = "Book1" }; if (sfd.ShowDialog() == true) { using (Stream stream = sfd.OpenFile()) { if (sfd.FilterIndex == 1) { workBook.Version = ExcelVersion.Excel97to2003; } else { workBook.Version = ExcelVersion.Excel2010; } workBook.SaveAs(stream); } //Message box confirmation to view the created spreadsheet. if (MessageBox.Show("Do you want to view the workbook?", "Workbook has been created", MessageBoxButton.YesNo, MessageBoxImage.Information) == MessageBoxResult.Yes) { //Launching the Excel file using the default Application.[MS Excel Or Free ExcelViewer] Open(sfd.FileName); } } } catch (Exception) { } }
private static void OnExecuteExportToExcel(object sender, ExecutedRoutedEventArgs args) { var dataGrid = args.Source as SfDataGrid; EccelOptionsConverter ExcelOption = new EccelOptionsConverter(); if (dataGrid == null) { return; } try { ExcelEngine excelEngine = new ExcelEngine(); if (!ExcelOption.IsCustomizeRow) { excelEngine = dataGrid.ExportToExcel(dataGrid.SelectedItems, new ExcelExportingOptions() { CellsExportingEventHandler = CellExportingHandler, ExportingEventHandler = ExportingHandler }); } else { excelEngine = dataGrid.ExportToExcel(dataGrid.SelectedItems, new ExcelExportingOptions() { CellsExportingEventHandler = CellExportingHandler, ExportingEventHandler = CustomizeExportingHandler }); } var workBook = excelEngine.Excel.Workbooks[0]; //saving the workbook using savefiledialog. SaveFileDialog sfd = new SaveFileDialog { FilterIndex = 2, Filter = "Excel 97 to 2003 Files(*.xls)|*.xls|Excel 2007 to 2010 Files(*.xlsx)|*.xlsx", FileName = "Book1" }; if (sfd.ShowDialog() == true) { using (Stream stream = sfd.OpenFile()) { if (sfd.FilterIndex == 1) { workBook.Version = ExcelVersion.Excel97to2003; } else { workBook.Version = ExcelVersion.Excel2010; } workBook.SaveAs(stream); } //Message box confirmation to view the created spreadsheet. if (MessageBox.Show("Do you want to view the workbook?", "Workbook has been created", MessageBoxButton.YesNo, MessageBoxImage.Information) == MessageBoxResult.Yes) { //Launching the Excel file using the default Application.[MS Excel Or Free ExcelViewer] System.Diagnostics.Process.Start(sfd.FileName); } } } catch (Exception) { } }