Why IsFreezePanes is a read only property

[Pierre-Alain GALTIER]

Hello,

I'm dynamically building a xls file and I want to fix the first row (in fact I want to 'freeze' a top panel that only contains the first row)

How could I do that when the IsFreezePanes is readonly ?

Should I declare a top panel (and how) ?

Thanks your for your help.

[kevin]

Don't worry, I found the magical instruction.

sheet.Range["A1"].FreezePanes();
sheet.HorizontalSplit = 1;
sheet.FirstVisibleRow = 2;

don't know if it is the best solution but it works.

[Manikandan M]

Hi Kevin,

Thanks for using Syncfusion products.

As you said, using FreezePanes method is correct solution to freeze the certain areas or panes in worksheet. We could see that your coding works correctly when we tested from our side.

For more information about Freezepane and SplitPane, Please visit the following links.

FreezePanes:
http://help.syncfusion.com/ug_94/Reporting/XlsIO/ASP.NET/default.htm?turl=Documents%2Ffreezepane.htm

SplitPane:
http://help.syncfusion.com/ug_94/Reporting/XlsIO/ASP.NET/default.htm?turl=Documents%2Fsplitpane.htm

Thanks for your patience. Please let us know if you need any clarifications.

Thanks,
Manikandan.M