Public/GetGHPullRequestReport.ps1

#Requires -Modules ImportExcel
function Get-GHPullRequestReport {
        <#
        .SYNOPSIS
        Get pull requests in a GitHub repository, and save them to Excel, and make a pivot table
         
        .EXAMPLE
        Get-GHIssueReport dfinke/importexcel
 
        .EXAMPLE
        Get-GHIssueReport dfinke/importexcel -closed
    #>


    param(
        [Parameter(ValueFromPipeline)]
        [string[]]$slug,
        [ValidateSet("open", "closed", "all")]
        $state = 'all',
        $XLFilename = "./GitHubStats.xlsx",        
        [int]$NumberOfPages = 1
    )

    Begin {
        $script:data = @()
    }

    Process {
        $data += foreach ($item in $slug) {
            Get-GHPullRequest $item -state $state -NumberOfPages $NumberOfPages
        }
    }        

    End {
        ExportReport PullRequests $data -XLFilename $XLFilename
    }
}