private static void OnExecuteExportToExcel(object sender, ExecutedRoutedEventArgs args) { var treeGrid = args.Source as SfTreeGrid; var optionsettings = args.Parameter as ExcelExportingOptionsWrapper; if (treeGrid == null || optionsettings == null) { return; } try { var options = new TreeGridExcelExportingOptions(); options.ExcelVersion = ExcelVersion.Excel2016; options.ExportingEventHandler = ExportingHandler; if (!optionsettings.CanCustomizeStyle) { options.CellsExportingEventHandler = CellExportingHandler; } else { options.CellsExportingEventHandler = CustomizeCellExportingHandler; } var excelEngine = treeGrid.ExportToExcel(options); var workBook = excelEngine.Excel.Workbooks[0]; SaveFile(workBook); } catch (Exception) { } }
public object Convert(object[] values, Type targetType, object parameter, System.Globalization.CultureInfo culture) { var options = new TreeGridExcelExportingOptions(); options.AllowOutliningGroups = (bool)values[0]; options.AllowIndentColumn = (bool)values[1]; options.IsGridLinesVisible = (bool)values[2]; options.CanExportHyperLink = (bool)values[3]; var value = (int)values[4]; options.NodeExpandMode = (value == 0 ? NodeExpandMode.Default : (value == 1 ? NodeExpandMode.ExpandAll : NodeExpandMode.CollapseAll)); isCutomized = (bool)values[5]; return(options); }
private static void OnExecuteExportToExcel(object sender, ExecutedRoutedEventArgs args) { var treeGrid = args.Source as SfTreeGrid; var optionsettings = args.Parameter as ExcelExportingOptionsWrapper; if (treeGrid == null || optionsettings == null) { return; } try { var options = new TreeGridExcelExportingOptions(); options.ExcelVersion = ExcelVersion.Excel2016; options.ExportingEventHandler = ExportingHandler; options.AllowIndentColumn = optionsettings.AllowIndentColumn; options.AllowOutliningGroups = optionsettings.AllowOutlining; options.IsGridLinesVisible = optionsettings.isgridLinesVisible; options.NodeExpandMode = (NodeExpandMode)optionsettings.NodeExpandModeIndex; if (!optionsettings.CanCustomizeStyle) { options.CellsExportingEventHandler = CellExportingHandler; } else { options.CellsExportingEventHandler = CustomizeCellExportingHandler; } var excelEngine = treeGrid.ExportToExcel(options); var workBook = excelEngine.Excel.Workbooks[0]; SaveFile(workBook); } catch (Exception) { } }
private async void OnExportToExcel(object sender, RoutedEventArgs e) { var options = new TreeGridExcelExportingOptions() { AllowOutliningGroups = (bool)AllowOutlining.IsChecked, AllowIndentColumn = (bool)AllowIndentColumn.IsChecked, IsGridLinesVisible = (bool)IsGridLinesVisible.IsChecked, CanExportHyperLink = (bool)CanExportHyperLink.IsChecked, NodeExpandMode = (nodeexpandMode.SelectedIndex == 0 ? NodeExpandMode.Default : (nodeexpandMode.SelectedIndex == 1 ? NodeExpandMode.ExpandAll : NodeExpandMode.CollapseAll)), ExcelVersion = ExcelVersion.Excel2013, ExportingEventHandler = ExportingHandler }; if ((bool)customizeColumns.IsChecked) { options.CellsExportingEventHandler = CustomizeCellExportingHandler; } excelEngine = new ExcelEngine(); IWorkbook workBook = excelEngine.Excel.Workbooks.Create(); treeGrid.ExportToExcel(workBook, options); var savePicker = new FileSavePicker { SuggestedStartLocation = PickerLocationId.DocumentsLibrary, SuggestedFileName = "Sample" }; if (workBook.Version == ExcelVersion.Excel97to2003) { savePicker.FileTypeChoices.Add("Excel File (.xls)", new List <string>() { ".xls" }); } else { savePicker.FileTypeChoices.Add("Excel File (.xlsx)", new List <string>() { ".xlsx" }); } var storageFile = await savePicker.PickSaveFileAsync(); if (storageFile != null) { await workBook.SaveAsAsync(storageFile); options.CellsExportingEventHandler = null; options.ExportingEventHandler = null; var msgDialog = new MessageDialog("Do you want to view the Document?", "File has been created successfully."); var yesCmd = new UICommand("Yes"); var noCmd = new UICommand("No"); msgDialog.Commands.Add(yesCmd); msgDialog.Commands.Add(noCmd); var cmd = await msgDialog.ShowAsync(); if (cmd == yesCmd) { // Launch the saved file bool success = await Launcher.LaunchFileAsync(storageFile); } } }