用Powershell在Excel中添加新工作表

# 创建Excel对象
$excel = New-Object -ComObject Excel.Application

# 隐藏Excel应用程序窗口
$excel.Visible = $false

# 打开现有的Excel文件
$workbook = $excel.Workbooks.Open("C:\path\to\your\excel\file.xlsx")

# 添加新工作表
$newWorksheet = $workbook.Worksheets.Add()

# 设置新工作表的名称
$newWorksheet.Name = "New Sheet"

# 保存并关闭Excel文件
$workbook.Save()
$workbook.Close()

# 退出Excel应用程序
$excel.Quit()

# 释放COM对象
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($newWorksheet) | Out-Null
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($workbook) | Out-Null
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($excel) | Out-Null
[System.GC]::Collect()
[System.GC]::WaitForPendingFinalizers()