How to export DetailsView records in expanded state from WPF DataGrid?

3 mins read

In WPF DataGrid (SfDataGrid) , you can export DataGrid to excel and it is possible to process the exported excel file using XlsIO. For example, you can expand the details view records in exported excel file alone by calling Range.ExpandGroup method for worksheet.

ExcelExportingOptions exportoption = new ExcelExportingOptions();
var excelengine = datagrid.ExportToExcel(datagrid.View, exportoption);
var workbook = excelengine.Excel.Workbooks[0];
workbook.Worksheets[0].Range.ExpandGroup(ExcelGroupBy.ByRows, ExpandCollapseFlags.IncludeSubgroups);

In the below screen shot, DetailsViewDataGrid expanded only in excel file and not in DataGrid.

Take a moment to peruse the WPF DataGrid - Exporting documentation, to learn more about exporting with examples.

View sample in GitHub

Conclusion

I hope you enjoyed learning on how to export the DetailsView records in expanded state from DataGrid to Excel.

You can refer to our WPF DataGrid feature tour page to know about its other groundbreaking feature representations and documentation, and how to quickly get started for configuration specifications. You can also explore our WPF DataGrid example to understand how to create and manipulate data.

For current customers, you can check out our components from the License and Downloads page. If you are new to Syncfusion, you can try our 30-day free trial to check out our other controls.

If you have any queries or require clarifications, please let us know in the comments section below. You can also contact us through our support forums, Direct-Trac, or feedback portal. We are always happy to assist you!

Did you find this information helpful?

Yes

Comments (0)

How to export DetailsView records in expanded state from WPF DataGrid?

Access denied