GetSheetPrintOptions Method

'Declaration
 
Public Function GetSheetPrintOptions( _
   ByVal sheet As Sheet, _
   Optional ByVal createIfNull As System.Boolean _
) As PrintOptionsBase

public PrintOptionsBase GetSheetPrintOptions( 
   Sheet sheet,
   System.bool createIfNull
)

Parameters

sheet

The sheet whose associated print options are to be retrieved.

createIfNull

True to create the print options if it has not yet been allocated. The options will be initialized based on the current state of the Sheet. Note the options should only have been null if there were no options for the Sheet when the Workbook was loaded. Also this will not allocate the collection unless the SavePrintOptions is true.

Return Value

Setting properties on the returned PrintOptionsBase instance will not change the actual print settings of the sheet. After setting properties, the Apply method of the CustomView will apply them to the sheet.

Target Platforms: Windows 8.1, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

CustomView Class
CustomView Members
PrintOptions Property
PrintOptions Property
SavePrintOptions Property