Represents a custom view in Microsoft Excel.
Inheritance
object
Properties
Section titled "Properties"Gets or sets the name of the custom view.
public string Name { get; set; }SaveHiddenRowsAndColumns
Section titled "SaveHiddenRowsAndColumns"Gets the value indicating whether hidden row and column settings are saved with the custom view.
public bool SaveHiddenRowsAndColumns { get; }SavePrintOptions
Section titled "SavePrintOptions"Gets the value indicating whether print options are saved with the custom view.
public bool SavePrintOptions { get; }WindowOptions
Section titled "WindowOptions"Gets the window options for the workbook associated with the custom view.
public CustomViewWindowOptions WindowOptions { get; }Methods
Section titled "Methods"Apply()
Section titled "Apply()"Applies all options from the custom view to the associated workbook and its worksheets.
public void Apply()Returns any
GetDisplayOptions(Worksheet, bool)
Section titled "GetDisplayOptions(Worksheet, bool)"Gets the display options associated with the specified worksheet.
public CustomViewDisplayOptions GetDisplayOptions(Worksheet worksheet, bool createIfNull = true)Parameters
- worksheet:
Worksheet - createIfNull:
bool
Returns any
GetHiddenColumns(Worksheet, bool)
Section titled "GetHiddenColumns(Worksheet, bool)"Gets the hidden columns associated with the specified worksheet.
public HiddenColumnCollection GetHiddenColumns(Worksheet worksheet, bool createIfNull = true)Parameters
- worksheet:
Worksheet - createIfNull:
bool
Returns any
GetHiddenRows(Worksheet, bool)
Section titled "GetHiddenRows(Worksheet, bool)"Gets the hidden rows associated with the specified worksheet.
public HiddenRowCollection GetHiddenRows(Worksheet worksheet, bool createIfNull = true)Parameters
- worksheet:
Worksheet - createIfNull:
bool
Returns any
GetPrintOptions(Worksheet, bool)
Section titled "GetPrintOptions(Worksheet, bool)"Gets the print options associated with the specified worksheet.
public PrintOptions GetPrintOptions(Worksheet worksheet, bool createIfNull = true)Parameters
- worksheet:
Worksheet - createIfNull:
bool
Returns any
GetSheetDisplayOptions(Sheet, bool)
Section titled "GetSheetDisplayOptions(Sheet, bool)"Gets the display options associated with the specified sheet.
public DisplayOptionsBase GetSheetDisplayOptions(Sheet sheet, bool createIfNull = true)Parameters
- sheet:
Sheet - createIfNull:
bool
Returns any
GetSheetPrintOptions(Sheet, bool)
Section titled "GetSheetPrintOptions(Sheet, bool)"Gets the print options associated with the specified sheet.
public PrintOptionsBase GetSheetPrintOptions(Sheet sheet, bool createIfNull = true)Parameters
- sheet:
Sheet - createIfNull:
bool