Get-ExcelSheetInfo

SYNOPSIS

Get worksheet names and their indices of an Excel workbook.

SYNTAX

Get-ExcelSheetInfo [-Path] <Object> [<CommonParameters>]

DESCRIPTION

The Get-ExcelSheetInfo cmdlet gets worksheet names and their indices of an Excel workbook.

EXAMPLES

EXAMPLE 1

Get-ExcelSheetInfo .\Test.xlsx

PARAMETERS

-Path

Specifies the path to the Excel file. (This parameter is required.)

Type: Object
Parameter Sets: (All)
Aliases: FullName

Required: True
Position: 0
Default value: None
Accept pipeline input: True (ByPropertyName, ByValue)
Accept wildcard characters: False

CommonParameters

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

INPUTS

OUTPUTS

NOTES

CHANGELOG 2016/01/07 Added Created by Johan Akerstrom (https://github.com/CosmosKey)

RELATED LINKS

https://github.com/dfinke/ImportExcel