A sheet in a Mirosoft Excel workbook that displays a single chart.
Inheritance
object
Properties
Section titled "Properties"HasProtectionPassword
Section titled "HasProtectionPassword"Inherited from: Sheet
Returns a boolean indicating if the Sheet has been protected with a password.
public bool HasProtectionPassword { get; }IsProtected
Section titled "IsProtected"Inherited from: Sheet
Returns a boolean indicating if the Worksheet has been protected.
public bool IsProtected { get; }Inherited from: Sheet
Gets or sets the sheet name.
public string Name { get; set; }Selected
Section titled "Selected"Inherited from: Sheet
Gets the value which indicates whether this worksheet is selected.
public bool Selected { get; }SheetIndex
Section titled "SheetIndex"Inherited from: Sheet
Gets the zero-based index of this sheet in its parent collection.
public int SheetIndex { get; }TabColorInfo
Section titled "TabColorInfo"Inherited from: Sheet
Gets or sets the to use for the associated sheet's tab in the tab bar of Microsoft Excel.
public WorkbookColorInfo TabColorInfo { get; set; }Workbook
Section titled "Workbook"Inherited from: Sheet
Gets the that owns the worksheet.
public Workbook Workbook { get; }Chart
Section titled "Chart"Returns the displayed in this chartsheet.
public WorksheetChart Chart { get; }DisplayOptions
Section titled "DisplayOptions"Gets the object which controls the display of the chartsheet.
public ChartsheetDisplayOptions DisplayOptions { get; }ImageBackground
Section titled "ImageBackground"Gets or sets the background image for the worksheet.
public ImageWrapper ImageBackground { get; set; }PrintOptions
Section titled "PrintOptions"Gets the object which controls how the chartsheet prints.
public ChartsheetPrintOptions PrintOptions { get; }Protection
Section titled "Protection"Returns an object that provides information used when the Chartsheet has been protected.
public ChartsheetProtection Protection { get; }Returns Chartsheet
public override SheetType Type { get; }Methods
Section titled "Methods"Unprotect(string)
Section titled "Unprotect(string)"Inherited from: Sheet
Attempts to use the specified password to remove the WorkSheet protection currently in place.
public void Unprotect(string password)Parameters
- password:
string
Returns any
Unprotect(SecureString)
Section titled "Unprotect(SecureString)"Inherited from: Sheet
Attempts to use the specified password to remove the Sheet protection currently in place.
public void Unprotect(SecureString password)Parameters
- password:
SecureString
Returns any
MoveToSheetIndex(int)
Section titled "MoveToSheetIndex(int)"Inherited from: Sheet
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
Unprotect()
Section titled "Unprotect()"Inherited from: Sheet
Removes the Sheet protection.
public void Unprotect()Returns any
Protect(bool?, bool?)
Section titled "Protect(bool?, bool?)"Protects the chartsheet without a password.
public void Protect(bool? allowEditObjects = null, bool? allowEditContents = null)Parameters
- allowEditObjects:
bool? - allowEditContents:
bool?
Returns any
Protect(SecureString, bool?, bool?)
Section titled "Protect(SecureString, bool?, bool?)"Protects the Chartsheet with the specified password.
public void Protect(SecureString password, bool? allowEditObjects = null, bool? allowEditContents = null)Parameters
- password:
SecureString - allowEditObjects:
bool? - allowEditContents:
bool?
Returns any
Protect(string, bool?, bool?)
Section titled "Protect(string, bool?, bool?)"Protects the Chartsheet with the specified password.
public void Protect(string password, bool? allowEditObjects = null, bool? allowEditContents = null)Parameters
- password:
string - allowEditObjects:
bool? - allowEditContents:
bool?