Hide sheet tabs and row & column headers

Question

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 · Answer

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 · Answer

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 · Answer

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 · Answer

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 · Answer

Thank you very much! We upgraded already :-)