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

Hide sheet tabs and row & column headers

Thread ID:





42870 Apr 7,2006 04:21 PM UTC Jun 8,2006 07:12 PM UTC WinForms 5
Tags: XlsIO
Asked On April 7, 2006 04:21 PM UTC

Hi! What would be the proper code to hide all sheet tabs and the row and column headers for all sheets? Thank you, Elsa

Administrator [Syncfusion]
Replied On April 10, 2006 05:32 AM UTC

Hi Elsa, Sorry for the delay in getting you. Use the following code to hide row and colum header. sheet.IsRowColumnHeadersVisible=false; Use the following code to hide sheet. sheet.Visibility=WorksheetVisibility.Hidden; Please take a look at the attachment and let me know if you need any further assistance. Hiding.zip BestRegards, Bharath.

Replied On April 10, 2006 04:16 PM UTC

Thank you for looking at my message! I implemented the IsRowColumnHeadersVisible property on the worksheet object just fine. What I need to do now is hide the sheet tab (not the worksheet itself). In Excel, this is done by clicking on Tools, Options, and unchecking "Sheet Tabs" in the View tab. How can I do this progremattically? I appreciate your time very much!

Administrator [Syncfusion]
Replied On April 11, 2006 05:46 AM UTC

Hi Elsa, I have requested a feature that will hide sheet tabs in a workbook to our development team.FeatureID:#887. We will inform you when this feature is available. BestRegards, Bharath.

Administrator [Syncfusion]
Replied On June 8, 2006 12:44 PM UTC

Hi Elsa, We are glad to inform you that this feature, for hiding sheet tabs in a workbook has been implemented in our latest version Please use the following code to hide the sheet tabs in a workbook. //Hiding the sheet tabs of a workbook. workbook.DisplayWorkbookTabs=false; Please take a look at the sample for your reference.Sample:HidingSheetTabs.zip Also please try to upgrade to our latest version which has some features added. Here is the download link for the latest version.DownloadLink: http://www2.syncfusion.com/Installs/v4.2.0.37/SyncfusionEssentialStudioSetup.exe Note: This version requires a separate key to install. Please contact sales if you have not received a key. Please take a look at the attachment and let me know if you need any assistance. Thanks, Bharath

Elsa C. Wood
Replied On June 8, 2006 07:12 PM UTC

Thank you very much! We upgraded already :-)


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

or the page will be automatically redirected to 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