powershell - 在 Excel 公式中包含正斜杠

Question

我有一组数据，例如“398”，我正在尝试添加正斜杠 ( / ) 以将该数字与另一个数字分隔开来。( 398 / 402 ) 输出应该是这样的。Powershell 认为我试图除以零。

我已经尝试过 "" / "" ，但这不起作用。

#ADD / Eventually add data

$counter = 2
$endcounter = 11
Write-Host "counter:" $counter

while ($counter -le $endcounter)
{
$countertwo = $counter
$formula = ("=" + "B" + $countertwo + "&" + "" / "")
Write-Host "formula:" $formula
#$counter++
Write-Host "Counter:" $counter
$countertwo = $counter
Write-Host "countertwo:" $countertwo
$WorkSheet.Cells.Item($countertwo,19).Formula = $formula
$counter++
Write-Host "Counter:" $counter
}

标签： powershellescaping

Answer 1

你没有正确地转义你的双引号。而不是这个：

$formula = ("=" + "B" + $countertwo + "&" + "" / "")

尝试其中之一：

$formula = ("=" + "B" + $countertwo + "&" + '" / "')
$formula = ("=" + "B" + $countertwo + "&" + """ / """)
$formula = ("=" + "B" + $countertwo + "&" + "`" / `"")