powershell将数据做成html,使用Powershell通过HTML格式的电子表格格式化输出

我试图从数组中构建表格，然后将其放入电子邮件中。我可以让表格显示数组中的第一个项目，但无法获取要列出的其余项目。我觉得我很接近，对我可能错过的东西有任何想法。使用Powershell通过HTML格式的电子表格格式化输出

$global:Report = "C:\TEMP\Scripts\PowerShell\ReadExcelFiles\File.csv"

$UViolation = import-csv $global:Report -Delimiter ' ' | Where-Object {$_.Rules -eq "TESTTEXTINFILE"}

$UserViolationDetails = New-Object System.Collections.ArrayList

foreach ($item in $UViolation){

if ($item.Destination -notcontains "HP ") {

$UserViolationDetails += ,@($item.'User Name', $item.'Occurred (Endpoint)',$item.'IP Address',$item.'Computer Name',$item.Destination)

}

}

$UserID = "USERID01"

$events = $UserViolationDetails -match $UserID

$count = 0

foreach ($line in $events){

$count++

$table = @(@{'User ID'=$line[0]; 'DateTime'=$line[1]})

}

$count

$table.ForEach({[PSCustomObject]$_}) | Format-Table -AutoSize

$ol = New-Object -comObject Outlook.Application

$mail = $ol.CreateItem(0)

$mail.To = "$global:UserReportsToEmail"

$mail.cc = "[email protected]"

$mail.Subject = "mySubject"

$mail.HTMLBody =

"TESTING STUFFFF!

Text on a new line $UserID
$table"

$inspector = $mail.GetInspector

$inspector.Display()

2016-10-26

MrMr