Powershell populate word table from an array-CodePudding

I have a PS script that will import a csv into several arrays and I need it to populate a table in word. I am able to get the data into the arrays, and create a table with headers and the correct number of rows, but cannot get the data from the arrays into the table. Doing lots of google searches led me to the following code. Any help is greatly appreciated.

Sample of My_File.txt Number of rows will vary, but the header row is always there.

component,id,iType,

VCT,AD-1234,Story,

VCT,Ad-4567,DR,

$component = @()
$id = @()
$iType =@()
$vFile = Import-CSV ("H:\My_file.txt")
$word = New-Object -ComObject "Word.Application"

$vFile | ForEach-Object {
$component  = $_.components
$id  = $_.id
$iType  =_.iType
}

$template = $word.Documents.Open ("H:\Test.docx")

$template = $word.Document.Add()
$word.Visible = $True
$Number_rows = ($vFile.count  1)
$Number_cols = 3

$range = $template.range()
$template.Tables.add($range, $Number_rows, $Number_cols) | out-null

$table = $template.Tables.Item(1)
$table.cell(1,1).Range.Text = "Component"
$table.cell(1,2).Range.Text = "ID"
$table.cell(1,3).Range.text = "Type"

for ($i=0; $i -lt; $vFile.count 2, $i  ){
$table.cell(($i 2),1).Range.Text = $component[$i].components
$table.cell(($i 2),2).Range.Text = $id[$i].id
$table.cell(($i 2),3).Range.Text = $iType[$i].iType
}

$Table.Style = "Medium Shading 1 - Accent 1"
$template.SaveAs("H:\New_Doc.docx")

CodePudding user response：

Don't separate the rows in the parsed CSV object array into three arrays, but leave the collection as-is and use the data to fill the table using the properties of that object array directly.

I took the liberty of renaming your variable $vFile into $data as to me at least this is more descriptive of what is in there.

Try

$data = Import-Csv -Path "H:\My_file.txt"
$word = New-Object -ComObject "Word.Application"
$word.Visible = $True

$template = $word.Documents.Open("H:\Test.docx")
$Number_rows = $data.Count  1  #  1 for the header
$Number_cols = 3

$range = $template.Range()
[void]$template.Tables.Add($range, $Number_rows, $Number_cols)

$table = $template.Tables.Item(1)
$table.Style = "Medium Shading 1 - Accent 1"

# write the headers
$table.cell(1,1).Range.Text = "Component"
$table.cell(1,2).Range.Text = "ID"
$table.cell(1,3).Range.text = "Type"

# next, add the data rows
for ($i=0; $i -lt $data.Count; $i  ){
    $table.cell(($i 2),1).Range.Text = $data[$i].component
    $table.cell(($i 2),2).Range.Text = $data[$i].id
    $table.cell(($i 2),3).Range.Text = $data[$i].iType
}

$template.SaveAs("H:\New_Doc.docx")

When done, do not forget to close the document, quit word and clean up the used COM objects:

$template.Close()
$word.Quit()

$null = [System.Runtime.Interopservices.Marshal]::ReleaseComObject($template)
$null = [System.Runtime.Interopservices.Marshal]::ReleaseComObject($word)
[System.GC]::Collect()
[System.GC]::WaitForPendingFinalizers()