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.
Unfortunately, activation email could not send to your email. Please try again.

Hide sheet tabs and row & column headers

Thread ID:

Created:

Updated:

Platform:

Replies:

42870 Apr 7,2006 12:21 PM Jun 8,2006 03:12 PM Windows Forms 5
loading
Tags: XlsIO
Elsa
Asked On April 7, 2006 12:21 PM

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 01:32 AM

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.

Elsa
Replied On April 10, 2006 12:16 PM

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 01:46 AM

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 08:44 AM

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 4.2.0.37. 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 4.2.0.37 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 03:12 PM

Thank you very much! We upgraded already :-)

CONFIRMATION

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.

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.

;