如何将选择从Telerik RadGridView导出到Excel

debugcn 发表于 Dev

戴维

我只想将RadGridView的选定行导出到Excel。我已经设法导出所有内容，但是如果用户选择了行，我只想将那些行从RadGridView导出到Excel。这是我的代码：（应该执行Todo）

 public void Execute_OpenExportView(RadGridView gridViewExport)
    {
        if (gridViewExport==null)
        {
            return;
        }

        string extension = "xlsx";
        SaveFileDialog dialog = new SaveFileDialog()
        {
            DefaultExt = extension,
            Filter = String.Format("{1} files (*.{0})|*.{0}|All files(*.*)|*.*", extension, "Excel"),
            FilterIndex = 1,
            AddExtension = true,
            Title = "Export to Excel",
            //FileName = 
        };


        //TODO export the selected rows from RadGRidView
        if (gridViewExport.SelectedItems.Count!=0)
        {


        }

        if (dialog.ShowDialog()==true)
        {
            using (Stream stream = dialog.OpenFile())
            {
                gridViewExport.ExportToXlsx(stream,
                    new GridViewDocumentExportOptions()
                    {
                        ShowColumnFooters = true,
                        ShowColumnHeaders = true,
                        ShowGroupFooters = true,
                        AutoFitColumnsWidth = true,
                    });
            }
        }

    }

捷克语

您可以使用GridViewDocumentExportOptions的内置Items属性，并将RadGridView的SelectedItems集合传递给它。请在Telerik UI for WPF文档中签出ExportFormat.Xlsx主题，以获取更多信息。

这将是您的代码中的解决方案：

 if (dialog.ShowDialog())
        {
            using (Stream stream = dialog.OpenFile())
            {
                gridViewExport.ExportToXlsx(stream,
                    new GridViewDocumentExportOptions()
                    {
                        Items = gridViewExport.SelectedItems,
                        ShowColumnFooters = true,
                        ShowColumnHeaders = true,
                        ShowGroupFooters = true,
                        AutoFitColumnsWidth = true,
                    });
            }
        }

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。