Search code examples
c#epplus

Freeze panes in Excel using C# and EPPlus

I want to freeze first 5 columns and three rows in excel. I have written the following code for that

Worksheets.View.FreezePanes(5, 5);

but it freezes columns in first 4 rows also. I want to freeze first 4 columns in excel except in first 4 rows. Is it possible to do?

Solution

  • The first value is for how many rows you want frozen, and the second is for how many columns you want frozen. Therefore, to freeze the first 3 rows and 5 columns you would need to call it as the following:

    Worksheets.View.FreezePanes(3, 5);

    You can also take a look at this SO question for more information on FreezePanes.