Freeze Top Row(s) of Excel Worksheet with C++

Introduction

In this article, we will learn how to freeze top row(s). When you have a huge amount of data under a common heading, you are unable to see the heading when scrolled down the worksheet. You can freeze top row(s) so that you can see that frozen portion even when the rest of the data is being scrolled. You can easily see headers in the top rows.

Freeze Rows In Excel

1. If you want to freeze top row(s), then first select the row under the row that needs to be frozen.
2. Click View > Freeze Panes.
3. On the drop-down menu, click Freeze Top Row.
4. If you scroll down, the first row is always in the top view.

As you can see, the 1st Row is frozen, and the first row always stays at the top of the view when you scroll down.

Freeze Rows let you view your large data without losing track of the row label.

Freeze Rows with Aspose.Cells for C++

It’s simple to freeze row(s) with Aspose.Cells for C++. Please use the Worksheet.FreezePanes method to freeze row(s) at the selected row.

1. Construct a Workbook to open the file or create an empty file.
2. Freeze the first row with the Worksheet.FreezePanes() method.
3. Save the file.

#include <iostream>
#include "Aspose.Cells.h"
using namespace Aspose::Cells;

int main()
{
    Aspose::Cells::Startup();

    // Instantiate a new Workbook
    Workbook workbook(u"Freeze.xlsx");

    // Freezing panes at the cell B2
    workbook.GetWorksheets().Get(0).FreezePanes(u"A2", 1, 0);

    // Saving the file
    workbook.Save(u"frozen.xlsx");

    std::cout << "Panes frozen successfully!" << std::endl;

    Aspose::Cells::Cleanup();
}

Attached sample source Excel file.