xlsx粘贴到txt文件中的数据，补充数据后转换到csv

xlsx_pasteTOcsv.ps1

$args = "path/to/paste/file"
$height = -2.333
$results = Select-String -Path $args -Pattern '(\d+[ |\t]{1})?(-?\d+\.?\d+)([ |\t]{1})(-?\d+\.?\d+)' -AllMatches
$ScriptPath = Split-Path -Parent $MyInvocation.MyCommand.Definition
$ScriptPath = $ScriptPath + '\' + [System.IO.Path]::GetFileNameWithoutExtension($args) + '.csv'
$results | foreach{
    $newline = "{0:0.000000},{1:0.000000},{2:0.000000}" -F [Double] $_.Matches[0].groups[2].value, [Double] $_.Matches[0].groups[4].value, $height
    $newline | Out-File -Encoding UTF8 -Append $ScriptPath
}