Add multidimensional array to html table in Powershell

Question

I have 2D array $dates with 2 columns and multiple rows for example:

$dates[0][0] = 2016.07.20
$dates[0][1] = 1
$dates[1][0] = 2016.08.19
$dates[1][1] = 6
...

I need to add this array to html output as table. For example I have style of html table:

$a = "<style>"
$a = $a + "TABLE{border-width: 2px;border-style: solid;border-color: black;border-collapse: collapse;}"
$a = $a + "TD{border-width: 1px;padding: 0px;border-style: solid;border-color: black;}"
$a = $a + "</style>"

When i use:

$dates | Select @{expression={$_}}| ConvertTo-HTML -head $a | out-file "C:\Test.htm"

I get this output, where they are in the same column:

<tr><td>2016.07.20 1</td></tr>
<tr><td>2016.08.19 6</td></tr>
<tr><td>2016.08.20 6</td></tr>

I need to have values be in different columns:

<tr><td>2016.07.20</td><td>1</td></tr>
<tr><td>2016.08.19</td><td>6</td></tr>
<tr><td>2016.08.20</td><td>6</td></tr>

Unfortunately I was unable to find examples how to fix that. Please can anyone help? How I can add values in different columns?

Whats wrong with the top results when googling your question title? Like PowerShell Build a 2D HTML table or Powershell: Display array-members in ConvertTo-HTML — woxxom
– woxxom, Commented Sep 7, 2016 at 13:40
What kinds of "columns" do the objects in $dates have? Is it just space-separated strings? Objects from a csv? — Mathias R. Jessen
– Mathias R. Jessen, Commented Sep 7, 2016 at 14:17
@MathiasR.Jessen - it is just 2-dimensional array of strings. — Alexey O
– Alexey O, Commented Sep 7, 2016 at 14:37
@wOxxOm in both these examples there are "-Header 'OU',..." or "select ComputerName -ExpandProperty Disks". But my array is pretty simple, no Headers, all items are like that: $dates[0][0] = 2016.07.20 ; $dates[0][1] = 1 ; $dates[1][0] = 2016.08.19 ; $dates[1][1] = 6 ... — Alexey O
– Alexey O, Commented Sep 7, 2016 at 14:40

woxxom · Accepted Answer · 2016-09-07 18:01:53Z

0

Concatenate the array manually:

'<tr>' + (
    ($dates | %{
        '<td>' + ($_ -join '</td><td>') + '</td>'
    }) -join "</tr>`n<tr>"
) + '</tr>'

answered Sep 7, 2016 at 18:01

woxxom

75.2k15 gold badges161 silver badges164 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Add multidimensional array to html table in Powershell

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related