How to freeze header row in exported excel file in WPF DataGrid (SfDataGrid) ?

1 min read

You can freeze the header row in the exported Excel sheet using FreezePanes method in IRange interface in WPF DataGrid (SfDataGrid).

//Select freeze pane range
//To freeze a row or column, the selected range should be next to the row or column.
IRange range = worksheet[2, 1];
//Create freeze pane in first row
range.FreezePanes();

Gif demo to show the header row freezed while scroll.

View WPF DataGrid Freeze Demo in GitHub.

Did you find this information helpful?

Yes

Comments (0)

How to freeze header row in exported excel file in WPF DataGrid (SfDataGrid) ?

Access denied