We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

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

Platform: WinForms |
Control: XlsIO |
Published Date: April 30, 2011 |
Last Revised Date: July 18, 2014

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.

C#

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

sheet.FirstVisibleRow = 10;

// Intializing the horizontal split to be 500.

sheet.HorizontalSplit = 500;

VB

' 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
ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon