Base class for a sheet in a Microsoft Excel workbook.

Inheritance

object

Classes that extend this class.

Derived Classes

Returns a boolean indicating if the Sheet has been protected with a password.

public bool HasProtectionPassword { get; }

Returns a boolean indicating if the Worksheet has been protected.

public bool IsProtected { get; }

Gets or sets the sheet name.

public string Name { get; set; }

Gets the value which indicates whether this worksheet is selected.

public bool Selected { get; }

Gets the zero-based index of this sheet in its parent collection.

public int SheetIndex { get; }

Gets or sets the to use for the associated sheet's tab in the tab bar of Microsoft Excel.

public WorkbookColorInfo TabColorInfo { get; set; }

Returns a value indicating the type of sheet

public abstract SheetType Type { get; }

Gets the that owns the worksheet.

public Workbook Workbook { get; }

Moves the sheet to a new position in the owning workbook's collections of sheets.

public void MoveToSheetIndex(int index)

Parameters

  • index: int

Returns any

Removes the Sheet protection.

public void Unprotect()

Returns any

Attempts to use the specified password to remove the Sheet protection currently in place.

public void Unprotect(SecureString password)

Parameters

  • password: SecureString

Returns any

Attempts to use the specified password to remove the WorkSheet protection currently in place.

public void Unprotect(string password)

Parameters

  • password: string

Returns any