powershell将表格发送到gmail

# 导入所需的模块
Import-Module -Name PowerShellGet
Import-Module -Name PSWriteHTML
Import-Module -Name PSWriteExcel
Import-Module -Name PSWriteWord
Import-Module -Name Send-MailMessage

# 创建一个HTML表格
$table = New-HTMLTable -Title "示例表格"
$table | Add-HTMLTableRow -Columns "姓名", "年龄", "性别"
$table | Add-HTMLTableRow -Columns "张三", "25", "男"
$table | Add-HTMLTableRow -Columns "李四", "30", "女"

# 将HTML表格保存为Excel文件
$table | ConvertTo-Excel -Path "表格.xlsx"

# 发送邮件
$smtpServer = "smtp.gmail.com"
$smtpPort = 587
$smtpUsername = "your-email@gmail.com"
$smtpPassword = "your-password"
$sender = "your-email@gmail.com"
$recipient = "recipient-email@gmail.com"
$subject = "表格发送示例"
$body = "请查收附件中的表格。"
$attachment = "表格.xlsx"

Send-MailMessage -SmtpServer $smtpServer -Port $smtpPort -UseSsl -Credential (Get-Credential -UserName $smtpUsername -Password $smtpPassword) -From $sender -To $recipient -Subject $subject -Body $body -Attachments $attachment