Cmdlet

Get-OfficeExcelSheetView

Module: PSWriteOffice
Inputs: OfficeIMO.Excel.ExcelDocument System.String[]
Outputs: PSWriteOffice.Models.Excel.ExcelSheetViewInfo
Source: GetOfficeExcelSheetViewCommand.cs:17 Edit on GitHub

Gets frozen panes, gridlines, direction, zoom and view mode for worksheets.

Syntax

Get-OfficeExcelSheetView
[-Document <ExcelDocument>]
[-Sheet <OfficeSheetSelector[]>]
[<CommonParameters>]

Parameter set: Document

Get-OfficeExcelSheetView
[-Path] <String[]>
[-Sheet <OfficeSheetSelector[]>]
[<CommonParameters>]

Parameter set: Path

Get-OfficeExcelSheetView
-LiteralPath <String[]>
[-Sheet <OfficeSheetSelector[]>]
[<CommonParameters>]

Parameter set: LiteralPath

Examples

Inspect report workbooks without editing them.

Get-ChildItem .\Reports -Filter *.xlsx | Get-OfficeExcelSheetView -Sheet Summary | Format-Table

Parameters

-Document ExcelDocument optionalpipeline: True (ByValue)sets: Document: Gets or sets a live workbook; omission uses the current worksheet or workbook scope.
-Sheet OfficeSheetSelector[] optional: Gets or sets worksheet names or wildcard patterns, one-based positions or native worksheet objects.
-Path String[] requiredposition: 0pipeline: True (ByValue)sets: Path: Gets or sets workbook paths with filesystem wildcard expansion.
-LiteralPath String[] requiredpipeline: True (ByPropertyName)aliases: FullName, PSPathsets: LiteralPath: Gets or sets literal workbook paths, including FileInfo.FullName and provider PSPath.

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.

Outputs

PSWriteOffice.Models.Excel.ExcelSheetViewInfo: A worksheet view snapshot with its workbook path and sheet name.