使用Powershell在Excel中添加复选框

Install-Module -Name ImportExcel
Import-Module -Name ImportExcel

$excel = New-Object -ComObject Excel.Application
$workbook = $excel.Workbooks.Add()
$worksheet = $workbook.Worksheets.Item(1)
$excel.Visible = $true

$checkbox = $worksheet.CheckBoxes().Add(100, 100, 100, 100)

$checkbox.Text = "复选框"
$checkbox.Value = $true

$workbook.SaveAs("C:\path\to\file.xlsx")
$workbook.Close()
$excel.Quit()