Freeze Panel feature in Excel

Aspose.Cells Product Family
1

Laurence,

Is there a “Freeze Panel” feature (similar to what excel has) in the excelWeb?

Thanks.

2

Dear michelle,

Thanks for you suggestion.

In Aspose.Excel.Web, this feature is not supported now. We will check the feasibility of this feature and will add it if possible.

3

@Michelle,
Aspose.Cells has replaced Aspose.Excel that is no more under active development now. This new product supports the web component to process Excel files. You can freeze/unfreeze panes as demonstrated in the following sample code:

Freeze Panes

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the reference of the worksheet that is currently active
GridWorksheet sheet = GridWeb1.WorkSheets[GridWeb1.ActiveSheetIndex];

// Freeze desired rows and columns
sheet.FreezePanes(row, column, noOfRows, noOfColumns);

Un-Freeze Panes

// Accessing the reference of the worksheet that is currently active
GridWorksheet sheet = GridWeb1.WorkSheets[GridWeb1.ActiveSheetIndex];

// Unfreezing rows and columns
sheet.UnFreezePanes();

Refer to the following article for more details:
Freeze and Unfreeze Panes

Download the free trial version here:
Aspose.Cells for .NET(Latest version)

Here is a runnable complete solution that contains a lot of examples to test different features of Aspose.Cells.