GetPrintOptions Method

Gets the print options associated with the specified worksheet.

Syntax

Visual Basic

'Declaration
 
Public Function GetPrintOptions( _
   ByVal worksheet As Worksheet, _
   Optional ByVal createIfNull As Boolean _
) As PrintOptions

C#

public PrintOptions GetPrintOptions( 
   Worksheet worksheet,
   bool createIfNull
)

Parameters

worksheet

The worksheet 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 Worksheet. Note the options should only have been null if there were no options for the Worksheet when the Workbook was loaded. Also this will not allocate the collection unless the SavePrintOptions is true.

Return Value

Null if SavePrintOptions is False or if the worksheet does not belong to the workbook associated with this custom view; otherwise, the print options associated with the worksheet.

Exceptions

Exception	Description
System.ArgumentNullException	worksheet is null.

Remarks

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

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, 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