Pdf in Excel Bestellnummern auslesen

# Ordner mit den auszulesenden PDF Dateien
$SOURCEFOLDER = "D:\Orders"  
# Ausgabedatei mit den Nummern
$OUTFILE = "D:\ordernummern.csv"  
# Extrahierungs-Muster
$REGEXPATTERN = '(?is)(?<=Order\s+)\d{7} ?[\d-]{8}\b'  
# ---------------------------------------
# function to get pdf page content
function Get-PDFContent {
    param(
        # absolute pdf file path
        [Parameter(mandatory=$true,ValueFromPipelineByPropertyName=$true)][Alias('Fullname')][string[]]$path,  
        # array of page indices from wich to extract page content
        [Parameter(mandatory=$false)][int[]]$page = -1,
        # optional regular expression pattern for string extraction
        [Parameter(mandatory=$false)][string]$pattern,
        # optional regex subgroup definition
        [Parameter(mandatory=$false)][int]$patterngroup = 0
    )
    begin {
        if (!('iTextSharp.text.pdf.PdfReader' -as [type])){  
	        # Funktion zum Laden des iTextSharp Assemblies
            function Load-iTextLibrary {
                if($psscriptroot -ne ''){  
                    $localpath = join-path $psscriptroot 'itextsharp.dll'  
                }else{
                    $localpath = join-path $env:TEMP 'itextsharp.dll'  
                }
                $zip = $null;$tmp = ''  
                try{
                    if(!(Test-Path $localpath)){
                        Add-Type -A System.IO.Compression.FileSystem
                        $tmp = "$env:TEMP\$([IO.Path]::GetRandomFileName())"  
                        write-host "Downloading and extracting required 'iTextSharp.dll' ... " -F Green -NoNewline  

                        (New-Object System.Net.WebClient).DownloadFile('https://www.nuget.org/api/v2/package/iTextSharp/5.5.13.1', $tmp)  
                        $zip = [System.IO.Compression.ZipFile]::OpenRead($tmp)
                        $zip.Entries | ?{$_.Fullname -eq 'lib/itextsharp.dll'} | %{  
                            [System.IO.Compression.ZipFileExtensions]::ExtractToFile($_,$localpath)
                        }
                        write-host "OK" -F Green   
                    }
                    if (Get-Item $localpath -Stream zone.identifier -ea SilentlyContinue){
                        Unblock-File -Path $localpath
                    }
                    Add-Type -Path $localpath
                }catch{
                    throw "Error: $($_.Exception.Message)"  
                }finally{
                    if ($zip){$zip.Dispose()}
                    if ($tmp -ne ''){del $tmp -Force -EA SilentlyContinue}  
                }
            }
            # iText Library laden
            Load-iTextLibrary
            # enable reading protected documents
            [iTextSharp.text.pdf.PdfReader]::unethicalreading = $true
        }
    }
    process{
        foreach($file in $path){
            $reader = $null
            try{
                $reader = New-Object iTextSharp.text.pdf.PdfReader $file
                if ($page -eq -1){
                    # Get content of all pages
                    $content = 1..($reader.NumberOfPages) | %{
                        [iTextSharp.text.pdf.parser.PdfTextExtractor]::GetTextFromPage($reader,$_)
                    }
                }else{
                    # Get content of specific pages
                    $content = $page | ?{$_ -in (1..$reader.NumberOfPages)} | %{
                        [iTextSharp.text.pdf.parser.PdfTextExtractor]::GetTextFromPage($reader,$_)
                    }
                }
                if($pattern -ne ''){  
                    [regex]::matches([string]$content,$pattern) | %{$_.Groups[$patterngroup].Value}
                }else{
                    $content
                }
            }catch{
                write-error "ERROR processing file '$file' : $($_.Exception.Message)"  
            }finally{
                if ($reader){$reader.Dispose()}
            }
        }
    }
}
# Extrahiere Daten aus allen gefundenen PDF-Dateien und schreibe das Ergebnis von Eindeutigen Werten inklusive Dateiname als CSV in die Ausgabedatei
$result = foreach($file in Get-ChildItem $SOURCEFOLDER -File -Filter *.pdf){
    Get-PDFContent $file.Fullname -pattern $REGEXPATTERN | select @{n='Filename';e={$file.Name}},@{n='Ordernumber';e={$_ -replace '\s'}} -Unique  
}
if ($result){
    $result | export-csv -LiteralPath $OUTFILE -Delimiter ";" -NoType -Encoding UTF8  
}else{
    write-host "Keine passenden Daten für Export gefunden!" -F Yellow  
}

powershell.exe -ExecutionPolicy ByPass -File "C:\Pfad\Script.ps1"

"C:\Pfad\script.ps1"

.\script.ps1

powershell.exe -File "C:\Pfad\Script.ps1"

powershell.exe -File "C:\Pfad\Script.ps1" "Parameter 1" "Parameter 2"

powershell.exe -command "&'C:\Pfad\Script.ps1' -par1 'Wert1' -par2 'Wert2'"

powershell.exe -command "&'C:\Pfad\Script1.ps1';&'C:\Pfad\Script2.ps1'"