Can't freeze pane on hidden spreadsheet

[Steve]

I have a sreadsheet I created to do an export to Excel, but it isn't visible, so the ActiveWorksheetEditor never gets created so I can't freeze panes. Is there any way around this?

[Boby]

Hi Steve,

Indeed ActiveWorksheet will be initialized when there are UI editor editing a specific worksheet. Instead, you can directly use the API of the WorksheetViewState for the worksheet that you get by index or by other means, for example:

Workbook workbook = new Workbook();
var worksheet = workbook.Worksheets.Add();
worksheet.ViewState.FreezePanes(1, 0);

// or

workbook.Worksheets[0].ViewState.FreezePanes(1, 0);

Let us know if you need additional information.

Regards,
Boby
Progress Telerik

[Edward]

To fix Excel freeze pane not working issue you can try the following fixes:

1# Change Page Layout View
2# Unprotect Worksheet
3# Unfreeze Worksheet Pane
4 # Use Table Instead Of Freeze Top Row