PSWriteExcel

0.0.15

Public/Get-ExcelWorkSheet.ps1

function Get-ExcelWorkSheet {
    [OutputType([OfficeOpenXml.ExcelWorksheet])]
    [cmdletBinding()]
    param (
        [OfficeOpenXml.ExcelPackage]  $ExcelDocument,
        [string] $Name,
        [nullable[int]] $Index,
        [switch] $All
    )
    if ($ExcelDocument) {
        if ($Name -and $Index) {
            Write-Warning 'Get-ExcelWorkSheet - Only $Name or $Index of Worksheet can be used.'
            return
        }
        if ($All) {
            $Data = $ExcelDocument.Workbook.Worksheets
        } elseif ($Name -or $Index -ne $null) {
            if ($Name) {
                $Data = $ExcelDocument.Workbook.Worksheets | Where { $_.Name -eq $Name }
            }
            if ($Index -ne $null) {
                if ($PSEdition -ne 'Core') {
                    $Index = $Index + 1
                }
                Write-Verbose "Get-ExcelWorkSheet - Index: $Index"
                $Data = $ExcelDocument.Workbook.Worksheets[$Index]
            }
        }
    }
    return $Data
}