Project

PSWriteOffice

PowerShell document automation across Word, Excel, PowerPoint, PDF, Reader, Confluence, Visio, and open text formats.

Stars 159

Forks 14

PowerShell Gallery downloads 158,661

Release v3.0.5

Language: C# Updated: 2026-09-03

API Reference

Cmdlet

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

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 <Normal|PageBreakPreview|PageLayout>] [-ZoomScale <UInt32>] [-ZoomScaleNormal <UInt32>] [<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 ExcelWorksheetViewKind optionalposition: namedpipeline: Falsevalues: 3: Worksheet view mode.; Possible values: Normal, PageBreakPreview, PageLayout
ZoomScale UInt32 optionalposition: namedpipeline: False: Active worksheet zoom percentage. Excel supports values from 10 to 400.
ZoomScaleNormal UInt32 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 <Int32>] [-ShowGridlines] [-View <Normal|PageBreakPreview|PageLayout>] [-ZoomScale <UInt32>] [-ZoomScaleNormal <UInt32>] [<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 Int32 optionalposition: namedpipeline: False: Worksheet index (0-based) when using Document.
ShowGridlines SwitchParameter optionalposition: namedpipeline: False: Show worksheet gridlines.
View ExcelWorksheetViewKind optionalposition: namedpipeline: Falsevalues: 3: Worksheet view mode.; Possible values: Normal, PageBreakPreview, PageLayout
ZoomScale UInt32 optionalposition: namedpipeline: False: Active worksheet zoom percentage. Excel supports values from 10 to 400.
ZoomScaleNormal UInt32 optionalposition: namedpipeline: False: Normal-view worksheet zoom percentage. Excel supports values from 10 to 400.