private void ExportaXLS_Click(object sender, RoutedEventArgs e) { var options = new Syncfusion.UI.Xaml.Grid.Converter.ExcelExportingOptions(); options.ExcelVersion = ExcelVersion.Excel2013; options.CellsExportingEventHandler = CellExportingHandler; var excelEngine = GridKardex.ExportToExcel(GridKardex.View, options); var workBook = excelEngine.Excel.Workbooks[0]; SaveFileDialog sfd = new SaveFileDialog { FilterIndex = 2, Filter = "Excel 97 to 2003 Files(*.xls)|*.xls|Excel 2007 to 2010 Files(*.xlsx)|*.xlsx|Excel 2013 File(*.xlsx)|*.xlsx" }; if (sfd.ShowDialog() == true) { using (Stream stream = sfd.OpenFile()) { if (sfd.FilterIndex == 1) { workBook.Version = ExcelVersion.Excel97to2003; } else if (sfd.FilterIndex == 2) { workBook.Version = ExcelVersion.Excel2010; } else { workBook.Version = ExcelVersion.Excel2013; } workBook.SaveAs(stream); } //Message box confirmation to view the created workbook. if (MessageBox.Show("Usted quiere abrir el archivo en excel?", "Ver archvo", 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); } } }
private void ExportaXLS_Click(object sender, RoutedEventArgs e) { try { var options = new Syncfusion.UI.Xaml.Grid.Converter.ExcelExportingOptions(); options.ExcelVersion = ExcelVersion.Excel2013; //options.ExcludeColumns.Add("idreg"); //options.ExcludeColumns.Add("cod_trn"); //options.ExcludeColumns.Add("nom_trn"); //options.ExcludeColumns.Add("num_trn"); //options.ExcludeColumns.Add("fec_trn"); //options.ExcludeColumns.Add("bod_tra"); //options.ExcludeColumns.Add("ent_uni"); //options.ExcludeColumns.Add("ent_cost"); //options.ExcludeColumns.Add("ent_ctotal"); //options.ExcludeColumns.Add("sal_uni"); //options.ExcludeColumns.Add("sal_cost"); //options.ExcludeColumns.Add("sal_ctotal"); //options.ExcludeColumns.Add("saldo_uni"); //options.ExcludeColumns.Add("saldo_cost"); //options.ExcludeColumns.Add("saldo_ctotal"); var excelEngine = GridKardex.ExportToExcel(GridKardex.View, options); var workBook = excelEngine.Excel.Workbooks[0]; SaveFileDialog sfd = new SaveFileDialog { FilterIndex = 2, Filter = "Excel 97 to 2003 Files(*.xls)|*.xls|Excel 2007 to 2010 Files(*.xlsx)|*.xlsx|Excel 2013 File(*.xlsx)|*.xlsx" }; if (sfd.ShowDialog() == true) { using (Stream stream = sfd.OpenFile()) { if (sfd.FilterIndex == 1) { workBook.Version = ExcelVersion.Excel97to2003; } else if (sfd.FilterIndex == 2) { workBook.Version = ExcelVersion.Excel2010; } else { workBook.Version = ExcelVersion.Excel2013; } workBook.SaveAs(stream); } //Message box confirmation to view the created workbook. if (MessageBox.Show("Usted quiere abrir el archivo en excel?", "Ver archvo", 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 w) { MessageBox.Show("error al exportar:" + w); } }