Excel 中的凍結窗格

上面的程式碼範例展示如何建立一個凍結窗格，將行和列鎖定在原位，使其在滾動時保持可見。 在快速比較資訊時，保持標題列或行的位置不變是一個非常實用的功能。

CreateFreezePane(column, row)

第一個 CreateFreezePane 方法重載接受列數和行數，並根據這些值建立一個凍結窗格。 例如，workSheet.CreateFreezePane(1, 4) 將從列 (A)和行 (1-4)建立凍結窗格。

CreateFreezePane(column, row, subsequentColumn, subsequentRow)

此重載操作會根據提供的列數和行數建立凍結窗格，並對工作表套用捲動功能。 例如，workSheet.CreateFreezePane(5, 2, 6, 7) 將從列 (AE)和行 (1-2)凍結窗格，並具有1 列和5 行滾動。 首次開啟工作表時，將顯示 AE 列、G 列… 行將顯示 1-2、8-...

如果你的 Excel 表格資料量很大，凍結行或列會很有用。 這樣，在滾動瀏覽工作表的其餘部分時，就可以保持某些行或列可見。

你可以從這個鏈接下載項目文件。

## 如何使用 C# 在 Excel 中新增凍結窗格
  1. 下載一個 C# 函式庫，用於在 Excel 中新增凍結窗格。
  2. 載入現有電子表格或建立新電子表格
  3. 使用`CreateFreezePane`方法新增凍結窗格
  4. 指定第三個和第四個參數以應用預滾動。
  5. 匯出編輯後的Excel 文件

學習如何使用 C# 在 Excel 中新增凍結窗格

相關文檔連結

回報此頁面的問題

A PHP Error was encountered

Severity: Notice

Message: Undefined index: IronXl.Excel

Filename: helpers/counter_helper.php

Line Number: 85

Backtrace:

File: /var/www/ironpdf.com/application/helpers/counter_helper.php
Line: 85
Function: _error_handler

File: /var/www/ironpdf.com/application/views/main/sections/ready_to_started_202509.php
Line: 12
Function: getTotalDonwloadNumber

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 489
Function: view

File: /var/www/ironpdf.com/application/controllers/Products/Examples.php
Line: 44
Function: render_products_view

File: /var/www/ironpdf.com/index.php
Line: 292
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined index: IronXl.Excel

Filename: helpers/counter_helper.php

Line Number: 85

Backtrace:

File: /var/www/ironpdf.com/application/helpers/counter_helper.php
Line: 85
Function: _error_handler

File: /var/www/ironpdf.com/application/views/main/sections/ready_to_started_202509.php
Line: 19
Function: getTotalDonwloadNumber

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 489
Function: view

File: /var/www/ironpdf.com/application/controllers/Products/Examples.php
Line: 44
Function: render_products_view

File: /var/www/ironpdf.com/index.php
Line: 292
Function: require_once

準備好開始了嗎？
Nuget 下載 1,890,100 | 版本： 2026.3 剛剛發布

A PHP Error was encountered

Severity: Notice

Message: Undefined index: IronXl.Excel

Filename: helpers/counter_helper.php

Line Number: 85

Backtrace:

File: /var/www/ironpdf.com/application/helpers/counter_helper.php
Line: 85
Function: _error_handler

File: /var/www/ironpdf.com/application/views/main/sections/still_scrolling_202512.php
Line: 17
Function: getTotalDonwloadNumber

File: /var/www/ironpdf.com/application/views/products/examples/index.php
Line: 270
Function: view

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 88
Function: view

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 552
Function: view

File: /var/www/ironpdf.com/application/controllers/Products/Examples.php
Line: 44
Function: render_products_view

File: /var/www/ironpdf.com/index.php
Line: 292
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined index: IronXl.Excel

Filename: helpers/counter_helper.php

Line Number: 85

Backtrace:

File: /var/www/ironpdf.com/application/helpers/counter_helper.php
Line: 85
Function: _error_handler

File: /var/www/ironpdf.com/application/views/main/sections/still_scrolling_202512.php
Line: 24
Function: getTotalDonwloadNumber

File: /var/www/ironpdf.com/application/views/products/examples/index.php
Line: 270
Function: view

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 88
Function: view

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 552
Function: view

File: /var/www/ironpdf.com/application/controllers/Products/Examples.php
Line: 44
Function: render_products_view

File: /var/www/ironpdf.com/index.php
Line: 292
Function: require_once

Still Scrolling Icon

還在捲動嗎？

想要快速證明？ PM > Install-Package IronXl.Excel
執行範例 觀看您的資料變成試算表。