这段PowerShell代码可以创建Excel表格。
我正在尝试冻结顶部行:
$excel = New-Object -Com Excel.Application
$excel.Visible = $True
$wb = $Excel.Workbooks.Add()
$ws = $wb.Worksheets.Add()
$ws.Activate()
$ws.Select()
$excel.Rows.Item("1:1").Select()
$excel.ActiveWindow.FreezePanes = $true
与其冻结顶部行,它会冻结行和列的中心,即:
更新
重复帖子中的解决方案无效,即:
$excel.Rows("1:1").Select()
$excel.ActiveWindow.FreezePanes = $true
出现以下错误:
Method invocation failed because [System.__ComObject] does not contain a method named 'Rows'.
At D:\Script\upgrades.ps1:231 char:5
+ $excel.Rows("1:1").Select()
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (Rows:String) [], RuntimeException
+ FullyQualifiedErrorId : MethodNotFound