ImportExcel

2.1

Import-Html.ps1

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

                                function Import-Html {

    [CmdletBinding()]

    param(

        $url,        

        $index

    )

    $xlFile = (New-TemporaryFile).fullname -replace "tmp","xlsx"

    rm $xlFile -ErrorAction Ignore

    Write-Verbose "Exporting to Excel file $($xlFile)"

    Get-HtmlTable $url $index |

        Export-Excel $xlFile -Show -AutoSize

}