CSV zu HTML konvertieren
Wer eine CSV wie bei Convert-Table2HTML zu HTML konvertieren will, ohne den Zwischenweg des CSV-Imports zu gehen, kann diese Funktion nutzen.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 |
function Convert-CSV2HTML { <# .SYNOPSIS Convert a CSV File to a HTML-Table. .DESCRIPTION The Convert-CSV2HTML cmdlet converts a CSV File to a HTML-Table in order to send it via email and have it available directly within the email. .PARAMETER CSVFile Specifies the path to the CSV file. .PARAMETER Delimiter Specifies the delimiter for the CSV File. .PARAMETER Encoding Specifies the encoding of the CSV File. .EXAMPLE PS C:\> Convert-CSV2HTML -CSVFile 'E:\Reports\DailyReport.csv' -Delimiter ';' -Encoding 'UTF8' .NOTES Author: Joachim Armbruster Blog : http://PowerShell24.de/ #> Param ( [parameter(Mandatory=$true)][String]$CSVFile, [String]$Delimiter, [String]$Encoding ) $Farbe1 = "bgcolor='#c5c5c5'" $Farbe2 = "bgcolor='#f0f0f0'" $CSVContent = Import-Csv $CSVFile -Delimiter $Delimiter -Encoding $Encoding $NoteProperties = $CSVContent | Get-Member -Type *Property* $html = "<table border='1'>" $html += "<tr>" foreach($NoteProperty in $NoteProperties) { $NotePropertyName = $NoteProperty.Name $html += "<th>$NotePropertyName</th>" } $html += "</tr>" $FarbenCounter = 0 for ($i = 0; $i -lt $CSVContent.Count; $i++) { if(($FarbenCounter % 2) -eq 0) { $bgcolor = $Farbe1 }else { $bgcolor = $Farbe2 } $html += "<tr " + $bgcolor + ">" foreach($NoteProperty in $NoteProperties) { $NotePropertyName = $NoteProperty.Name $Eintrag = $CSVContent[$i].$NotePropertyName $html += "<td>$Eintrag</td>" } $html += "</tr>" $FarbenCounter++ } $html += "</table>" return $html } |