Set-OfficeExcelWorksheetView

Aliases: ExcelSheetView

Namespace PSWriteOffice

Aliases

ExcelSheetView

Inputs

OfficeIMO.Excel.ExcelDocument

Source

Sources/PSWriteOffice/Cmdlets/Excel/SetOfficeExcelWorksheetViewCommand.cs:16 Edit on GitHub

Sets worksheet view options such as gridlines, direction, zoom, and view mode.

Remarks

Sets worksheet view options such as gridlines, direction, zoom, and view mode.

Examples

Authored help example

Example 1: Apply common worksheet view options.

PS>


ExcelSheet 'Data' { Set-OfficeExcelWorksheetView -HideGridlines -ZoomScale 125 -View PageLayout }

Hides gridlines, sets zoom, and switches the sheet view.

Common Parameters

This command supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable.

For more information, see about_CommonParameters.

Syntax

Set-OfficeExcelWorksheetView [-HideGridlines] [-LeftToRight] [-PassThru] [-RightToLeft] [-ShowGridlines] [-View <Nullable`1>] [-ZoomScale <Nullable`1>] [-ZoomScaleNormal <Nullable`1>] [<CommonParameters>]

Parameter set: Context

Parameters

HideGridlines SwitchParameter optionalposition: namedpipeline: False: Hide worksheet gridlines.
LeftToRight SwitchParameter optionalposition: namedpipeline: False: Show worksheet left-to-right.
PassThru SwitchParameter optionalposition: namedpipeline: False: Emit the worksheet after applying view options.
RightToLeft SwitchParameter optionalposition: namedpipeline: False: Show worksheet right-to-left.
ShowGridlines SwitchParameter optionalposition: namedpipeline: False: Show worksheet gridlines.
View Nullable`1 optionalposition: namedpipeline: False: Worksheet view mode. Possible values: Normal, PageBreakPreview, PageLayout
ZoomScale Nullable`1 optionalposition: namedpipeline: False: Active worksheet zoom percentage. Excel supports values from 10 to 400.
ZoomScaleNormal Nullable`1 optionalposition: namedpipeline: False: Normal-view worksheet zoom percentage. Excel supports values from 10 to 400.

Set-OfficeExcelWorksheetView -Document <ExcelDocument> [-HideGridlines] [-LeftToRight] [-PassThru] [-RightToLeft] [-Sheet <String>] [-SheetIndex <Nullable`1>] [-ShowGridlines] [-View <Nullable`1>] [-ZoomScale <Nullable`1>] [-ZoomScaleNormal <Nullable`1>] [<CommonParameters>]

Parameter set: Document

Parameters

Document ExcelDocument requiredposition: namedpipeline: True (ByValue): Workbook to operate on outside the DSL context.
HideGridlines SwitchParameter optionalposition: namedpipeline: False: Hide worksheet gridlines.
LeftToRight SwitchParameter optionalposition: namedpipeline: False: Show worksheet left-to-right.
PassThru SwitchParameter optionalposition: namedpipeline: False: Emit the worksheet after applying view options.
RightToLeft SwitchParameter optionalposition: namedpipeline: False: Show worksheet right-to-left.
Sheet String optionalposition: namedpipeline: False: Worksheet name when using Document.
SheetIndex Nullable`1 optionalposition: namedpipeline: False: Worksheet index (0-based) when using Document.
ShowGridlines SwitchParameter optionalposition: namedpipeline: False: Show worksheet gridlines.
View Nullable`1 optionalposition: namedpipeline: False: Worksheet view mode. Possible values: Normal, PageBreakPreview, PageLayout
ZoomScale Nullable`1 optionalposition: namedpipeline: False: Active worksheet zoom percentage. Excel supports values from 10 to 400.
ZoomScaleNormal Nullable`1 optionalposition: namedpipeline: False: Normal-view worksheet zoom percentage. Excel supports values from 10 to 400.