Search Results for

    Show / Hide Table of Contents

    Class HiddenState

    Enum that represents visibility of the worksheet.

    Inheritance
    System.Object
    HiddenState
    Namespace: IronXL.Options
    Assembly: IronXL.dll
    Syntax
    public sealed class HiddenState : Enum

    HiddenState selects how visible a worksheet is within a workbook, set on a worksheet's visibility. Visible is the normal state, where the tab shows and a user can switch to it. Hidden removes the tab from view but lets a user unhide it through Excel, while VeryHidden conceals the sheet so it cannot be unhidden through the interface and only code can restore it, which suits sheets holding lookup data a user should not see. The manage worksheets how-to covers showing and hiding sheets.

    worksheet.State = HiddenState.VeryHidden;

    Fields

    Hidden

    Worksheet is hidden.

    Declaration
    public const HiddenState Hidden
    Field Value
    Type Description
    HiddenState

    value__

    Declaration
    public int value__
    Field Value
    Type Description
    System.Int32

    VeryHidden

    Worksheet is very hidden.

    Declaration
    public const HiddenState VeryHidden
    Field Value
    Type Description
    HiddenState

    Visible

    Worksheet is visible.

    Declaration
    public const HiddenState Visible
    Field Value
    Type Description
    HiddenState
    ☀
    ☾
    Downloads
    • Download with Nuget
    • Start for Free
    In This Article
    Back to top
    Install with Nuget
    %s requires a valid license key for further deployment. Get Trial Below.
    ironsuite
    Blue key in circleGet Started for Free
    30 days full access • No credit card required
    Test in a live environment

    Test in production without watermarks.
    Works wherever you need it to.

    Fully-functional product

    Get 30 days of fully functional product.
    Have it up and running in minutes.

    24/5 technical support

    Full access to our support engineering team during your product trial

    Grey key in circleGet Started for Free
    The trial form was submitted successfully.
    Grey check in circleTrial key delivered
    Your key has been issued and sent to your email.
    Calendar in circleBook Free Live Demo
    No cards • no pitches • no commitments Pick a time for a quick, personalized demo
    Get the most out of your 30-day trial with:

    Live product and key features walk-through

    Project-specific recommendations

    All your questions answered

    Grey key in circleBook Free Live Demo
    Your booking has been completed Check your e-mail for confirmation

    Want to deploy Iron Suite
    to a live project for FREE?

    What’s included?

    • Test in production without watermarks
    • 30 days fully functional product
    • 24/5 technical support during trial
    ironpdf Logo
    ironword Logo
    ironxl Logo
    ironppt Logo
    ironocr Logo
    ironbarcode Logo
    ironqr Logo
    ironprint Logo
    ironzip Logo
    ironwebscraper Logo
    Iron Software sales team
    Online 24/5
    Have Enterprise licensing requirements?
    Request Iron Suite Enterprise trial
    Key in blue circle

    Get your free 30-day Trial Key instantly

    Your trial license will be sent to your email address

    No limitations. 100% unlocked. No credit card.

    bullet_checkedNo credit card or account creation requiredNo limitations. 100% unlocked. No credit card.
    Or
    Key in blue circle

    Complete Your Trial Key Signup

    Tell us a little more about yourself.

    Key in blue circleNo credit card or account creation requiredNo limitations. 100% unlocked. No credit card.
    Key in blue circle

    Your license key has been delivered to your inbox

    Can't find it? Check your spam folder.

    What’s next?
    Install with NuGet
    Add IronXL to your project
    Quickstart Guide
    Helpful resources to get started

    Need help getting started?

    Book a Free Live Demo

    See IronXL in action and get your licensing questions answered, or

    Key in blue circle

    Your demo request is in.

    You'll receive an invite via email shortly.

    What’s next?
    Explore Documentation
    Review Licensing Options
    badge_greencheck_in_yellowcircle
    Thank you
    Your trial key should be in the email.
    If it is not, please contact support@ironsoftware.com
    • Logo Aetna
    • Logo NASA
    • Logo GE
    • Logo Porsche
    • Logo USDA
    • Logo Qatar
    Join Millions of Engineers who’ve tried IronXL
    Your trial key should be in the email.
    If it is not, please contact support@ironsoftware.com