Page History

...

Remarks

Freeze panes can only be applied to the first few rows or first few columns of a worksheet. This is a limitation of Excel and not ExcelWriter.

Image Removed

Web only

	.
	.

!Excel_FreezePane_Options.png!

Web only

Example

Code Block

	csharp
	csharp
title	C#


          //--- Get FreezePanes
          Cell freezeCell = ws.FreezePanes;

          //--- Set FreezePanes for rows 1-5 and columns A, B
          ws.FreezePanes = ws.Cells["C5"];

Code Block

	vb.net
	vb.net
title	vb.net


          '--- Get FreezePanes
          Dim freezeCell As Cell = ws.FreezePanes

          '--- Set FreezePanes for rows 1-5 and columns A, B
          ws.FreezePanes = ws.Cells("C5");

Space Shortcuts

Page tree

Versions Compared

Old Version 4

New Version Current

Key