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

#テーブルを作成
$table = $worksheet.ListObjects.Add([Microsoft.Office.Interop.Excel.XlListObjectSourceType]::xlSrcRange,$worksheet.Range("A1:C3"),[Microsoft.Office.Interop.Excel.XlYesNoGuess]::xlYes)
$table.Name = "TestTable"

#テーブルに行を追加
$newRow = $table.ListRows.Add()
$newRow.Range.Cells.Item(1) = "test1"
$newRow.Range.Cells.Item(2) = "test2"
$newRow.Range.Cells.Item(3) = "test3"

# 保存先フォルダの存在確認
$targetFolder = $PSScriptRoot
if (!(Test-Path $targetFolder)) {
  New-Item -ItemType Directory -Path $targetFolder
}

# すでに存在する場合削除する
$targetFile = "$($targetFolder)¥people.xlsx"
if (Test-Path $targetFile) {
  Remove-Item $targetFile
}

# 保存する
$workbook.SaveAs($targetFile)

# エクセルを閉じる
$excel.Quit()

[System.Runtime.Interopservices.Marshal]::ReleaseComObject($excel) | Out-Null
Remove-Variable -Name excel