How do I keep the headers visible while scrolling down through data?

1 min read

The headers can be kept visible by using Freeze pane. Here is the sample code for keeping the headers visible while scrolling down through data using XlsIO.

// Initializing the first visible row to be the tenth row.

sheet.FirstVisibleRow = 10;

// Intializing the horizontal split to be 500.

sheet.HorizontalSplit = 500;

' Initializing the first visible row to be the tenth row.

sheet.FirstVisibleRow = 10

' Intializing the horizontal split to be 500.

sheet.HorizontalSplit = 500

Sample

http://www.syncfusion.com/downloads/support/directtrac/general/HeaderVisible-1751603250.zip

Did you find this information helpful?

Yes

Comments (0)