private void btnExport_Click(object sender, RoutedEventArgs e) { try { string fileName = System.IO.Path.GetTempPath() + "TempFile.xlsx"; DataPresenterExcelExporter excelExporter = new DataPresenterExcelExporter(); excelExporter.ExportAsync(this.xamDataGridControl, fileName, WorkbookFormat.Excel2007); System.Windows.MessageBox.Show("File save successfully. \n" + fileName); } catch (Exception ex) { System.Windows.MessageBox.Show(ex.Message); } }
private void Export2Excel_Click(object sender, RoutedEventArgs e) { string fileName = @"c:\temp\3\a.xlsx"; try { // Get the instance of the DataPresenterExcelExporter we defined in the Page's resources and call its Export // method passing in the XamDataGrid we want to export, the name of the file we would like // to export to and the format of the Workbook we want to Exporter to create. // // NOTE: there are 11 overloads to the Export method that give you control over different // aspects of the exporting process. DataPresenterExcelExporter exporter = (DataPresenterExcelExporter)this.Resources["Exporter"]; ExportOptions op = new ExportOptions(); op.ChildRecordCollectionSpacing = ChildRecordCollectionSpacing.None; op.ExcludeExpandedState = true; op.ExcludeSummaries = true; exporter.Export(CSTGrid, fileName, WorkbookFormat.Excel2007, op); } catch (Exception ex) { // It's possible that the exporter does not have permission to write the file, so it's generally // a good idea to account for this possibility. MessageBox.Show(string.Format("Export_Message_ExcelExportError_Text", ex.Message), "Export_Message_ExcelError_Caption", MessageBoxButton.OK, MessageBoxImage.Exclamation); return; } // Execute Excel to display the exported workbook. try { Process p = new Process(); p.StartInfo.FileName = fileName; p.Start(); } catch (Exception ex) { MessageBox.Show(string.Format("Export_Message_ExcelError_Text", ex.Message), "Export_Message_ExcelError_Caption", MessageBoxButton.OK, MessageBoxImage.Exclamation); } }
protected ViewModelBaseCanExportToExcel(IUnityContainer container) : base(container) { ExportToExcel = new DelegateCommand <XamDataGrid>(grid => { var messageService = Container.Resolve <IMessageService>(); var fileName = $"{this.GetType().Name}-{DateTime.Now.ToFileTime()}.xlsx"; try { var exporter = new DataPresenterExcelExporter(); exporter.Export(grid, fileName, WorkbookFormat.Excel2007, this.ExportOptions); } catch (Exception ex) { messageService.ShowOkMessageDialog("ќшибка экспорта в файл", ex.PrintAllExceptions()); return; } // Execute Excel to display the exported workbook. if (messageService.ShowYesNoMessageDialog("Ёкспорт успешно завершен", "ѕоказать результаты экспорта?", defaultYes: true) == MessageDialogResult.Yes) { try { var p = new Process { StartInfo = { FileName = fileName } }; p.Start(); } catch (Exception ex) { messageService.ShowOkMessageDialog("ќшибка", ex.PrintAllExceptions()); } } }); }
private void exportButton_Click(object sender, RoutedEventArgs e) { DataPresenterExcelExporter exporter = new DataPresenterExcelExporter(); exporter.ExportAsync(this.dg1, "C:\\Users\\Himanshu\\Documents\\SaleAllocationReports\\PosSaleReport.xlsx", WorkbookFormat.Excel2007); }