Freeze First Column(s) of Excel Worksheet with C++

Introduction

In this article, we will learn how to freeze left column(s). When you have a huge amount of data in a row, so you are unable to see the left columns when horizontally scrolled down the worksheet. You can freeze and lock first column(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 left columns.

Freeze Columns In Excel

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

As you can see, the 1st column is frozen, the first column is always locked at the top of the view when you scroll horizontally.

Freeze Columns let you view your long data without keeping track of the first column.

Freeze Columns with Aspose.Cells for C++

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

1. Construct Workbook to open the file or create an empty file.
2. Freeze the first column with 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 second column
    workbook.GetWorksheets().Get(0).FreezePanes(u"B1", 0, 1);

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

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

    Aspose::Cells::Cleanup();
}

Attached sample source Excel file.