2X faster development
The ultimate WPF UI toolkit to boost your development speed.
You can export WPF DataGrid (SfDataGrid) 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, DetailsView DataGrid expanded only in excel file and not in SfDataGrid. Samples: |
2X faster development
The ultimate WPF UI toolkit to boost your development speed.
This page will automatically be redirected to the sign-in page in 10 seconds.