Excel toc generation

New-TableOfContents.ps1

function New-TableOfContents {
    <#
        .EXAMPLE
        $excelfile = 'C:\temp\test.xlsx'
        $toc = New-TableOfContents -ExcelFile $excelfile
        $toc | Export-Excel -Path $ExcelFile -WorksheetName 'TOC' -Title "Table of Contents" -MoveToStart
    #>
    [CmdletBinding()]
    param(
        [Parameter(Mandatory)]
        [string]$ExcelFile
    )
    Get-ExcelSheetInfo -Path $ExcelFile | ForEach-Object {
        [PSCustomObject]@{
            Name  = $_.Name -creplace '(?<=\w)([A-Z])', ' $1'
            Index = $_.Index
            Link  = "XL://internal/{0}!A1" -f $_.Name
            # something like this should also work, breaks atm but works when pasting into xlsx.. 
            # AltLink = [string]::Concat('=HYPERLINK("#', "'", $_.Name, "'", '!A1";', '"', 'Goto ', $_.Name, '"', ')')

        }
    }
}