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: System.Object
Parameter Sets: (All)
Aliases: FullName
Required: True
Position: 1
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)