Example of Freeze Panes in ASP.NET Core Spreadsheet Control

Spreadsheet
Freeze Panes

This sample demonstrates the Spreadsheet freeze pane feature by applying frozen rows and columns with the Gross Salary scenario as an example. In this sample, you can see the frozen rows/columns that are visible while scrolling the sheet content vertically/horizontally.

AB
1Period
2MonthYear
CDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBA
Total Gross Salary
BasicSalaryRevisedBasicSalaryDARevisedDAHRARevisedHRAConveyanceAllowanceRevisedConveyanceAllowanceMedicalExpensesRevisedMedicalExpensesSpecialAllowanceRevisedSpecialAllowanceTotalGrossSalaryRevisedTotalGrossSalary
3January2019
4February2019
5March2019
6April2019
7May2019
8June2019
9July2019
10August2019
11September2019
12October2019
13November2019
14December2019
15January2020
16February2020
17March2020
18April2020
19May2020
20June2020
21July2020
22August2020
23September2020
$15,100.00$15,800.00$2,000.00$2,200.00$5,000.00$6,500.00$1,500.00$1,700.00$1,250.00$1,500.00$1,000.00$1,200.00$25,850.00$28,900.00
$15,100.00$15,800.00$2,000.00$2,200.00$5,000.00$6,500.00$1,500.00$1,700.00$1,250.00$1,500.00$1,000.00$1,200.00$25,850.00$28,900.00
$15,100.00$15,800.00$2,000.00$2,200.00$5,000.00$6,500.00$1,500.00$1,700.00$1,250.00$1,500.00$1,000.00$1,200.00$25,850.00$28,900.00
$15,100.00$15,800.00$2,000.00$2,200.00$5,000.00$6,500.00$1,500.00$1,700.00$1,250.00$1,500.00$1,000.00$1,200.00$25,850.00$28,900.00
$15,100.00$15,800.00$2,000.00$2,200.00$5,000.00$6,500.00$1,500.00$1,700.00$1,250.00$1,500.00$1,000.00$1,200.00$25,850.00$28,900.00
$15,100.00$15,800.00$2,000.00$2,200.00$5,000.00$6,500.00$1,500.00$1,700.00$1,250.00$1,500.00$1,000.00$1,200.00$25,850.00$28,900.00
$15,100.00$15,800.00$2,000.00$2,200.00$5,000.00$6,500.00$1,500.00$1,700.00$1,250.00$1,500.00$1,000.00$1,200.00$25,850.00$28,900.00
$15,100.00$15,800.00$2,000.00$2,200.00$5,000.00$6,500.00$1,500.00$1,700.00$1,250.00$1,500.00$1,000.00$1,200.00$25,850.00$28,900.00
$15,100.00$15,800.00$2,000.00$2,200.00$5,000.00$6,500.00$1,500.00$1,700.00$1,250.00$1,500.00$1,000.00$1,200.00$25,850.00$28,900.00
$15,100.00$15,800.00$2,000.00$2,200.00$5,000.00$6,500.00$1,500.00$1,700.00$1,250.00$1,500.00$1,000.00$1,200.00$25,850.00$28,900.00
$15,100.00$15,800.00$2,000.00$2,200.00$5,000.00$6,500.00$1,500.00$1,700.00$1,250.00$1,500.00$1,000.00$1,200.00$25,850.00$28,900.00
$15,100.00$15,800.00$2,000.00$2,200.00$5,000.00$6,500.00$1,500.00$1,700.00$1,250.00$1,500.00$1,000.00$1,200.00$25,850.00$28,900.00
$16,610.00$17,380.00$2,200.00$2,420.00$5,500.00$7,150.00$1,650.00$1,870.00$1,375.00$1,650.00$1,100.00$1,320.00$28,435.00$31,790.00
$16,610.00$17,380.00$2,200.00$2,420.00$5,500.00$7,150.00$1,650.00$1,870.00$1,375.00$1,650.00$1,100.00$1,320.00$28,435.00$31,790.00
$16,610.00$17,380.00$2,200.00$2,420.00$5,500.00$7,150.00$1,650.00$1,870.00$1,375.00$1,650.00$1,100.00$1,320.00$28,435.00$31,790.00
$16,610.00$17,380.00$2,200.00$2,420.00$5,500.00$7,150.00$1,650.00$1,870.00$1,375.00$1,650.00$1,100.00$1,320.00$28,435.00$31,790.00
$16,610.00$17,380.00$2,200.00$2,420.00$5,500.00$7,150.00$1,650.00$1,870.00$1,375.00$1,650.00$1,100.00$1,320.00$28,435.00$31,790.00
$16,610.00$17,380.00$2,200.00$2,420.00$5,500.00$7,150.00$1,650.00$1,870.00$1,375.00$1,650.00$1,100.00$1,320.00$28,435.00$31,790.00
$16,610.00$17,380.00$2,200.00$2,420.00$5,500.00$7,150.00$1,650.00$1,870.00$1,375.00$1,650.00$1,100.00$1,320.00$28,435.00$31,790.00
$16,610.00$17,380.00$2,200.00$2,420.00$5,500.00$7,150.00$1,650.00$1,870.00$1,375.00$1,650.00$1,100.00$1,320.00$28,435.00$31,790.00
$16,610.00$17,380.00$2,200.00$2,420.00$5,500.00$7,150.00$1,650.00$1,870.00$1,375.00$1,650.00$1,100.00$1,320.00$28,435.00$31,790.00
Total Gross Salary

Freeze Panes helps you to keep particular rows or columns visible when scrolling the sheet content in the spreadsheet. You can specify the number of frozen rows and columns using frozenRows and frozenColumns properties inside the `Sheet` property.

In this sample, the first 2 rows and columns are frozen using the `frozenRows` and `frozenColumns` properties.

More information about freeze pane can be found in this documentation section.

Transform your ASP.NET Core web apps today with Syncfusion® ASP.NET Core components
85+ high-performance and responsive UI components
Dedicated support
Hassle-free licensing
TRY IT FOR FREE
opens in a new tab