这里是一个例子，逐步通过我的意思是指导你。
初始化多维数组

Clear-Host
$MDArrayData = @(
    @('John','Mary','Sarah'), 
    @('23','44','31'), 
    @('Flying, Fishing','Dancing','Singing'), 
    @('Lucas','Simon, Lisa','Anna')
)

按索引从每个数组中挑选目标样本数据以确保验证成功。我使用PowerShell variable squeezing将结果赋给变量并同时输出到屏幕。

(
    $MyDataObject = [PSCustomObject]@{
        Name  = $MDArrayData[0][0]
        Age   = $MDArrayData[1][0]
        Hobby = $MDArrayData[2][0]
        Kids  = $MDArrayData[3][0]
    }
)
# Results
<#
Name Age Hobby           Kids 
---- --- -----           ---- 
John 23  Flying, Fishing Lucas
#>

枚举主数组，数组0，形成报表

Clear-Host
$MDArrayData = @(
    @('John','Mary','Sarah'), 
    @('23','44','31'), 
    @('Flying, Fishing','Dancing','Singing'), 
    @('Lucas','Simon, Lisa','Anna')
)

0..(($MDArrayData[0]).Count -1) | 
ForEach-Object {
    (
        $MyDataObject = [PSCustomObject]@{
            Name  = $MDArrayData[0][$PSItem]
            Age   = $MDArrayData[1][$PSItem]
            Hobby = $MDArrayData[2][$PSItem]
            Kids  = $MDArrayData[3][$PSItem]
        }
    )
}
# Results
<#
Name  Age Hobby           Kids       
----  --- -----           ----       
John  23  Flying, Fishing Lucas      
Mary  44  Dancing         Simon, Lisa
Sarah 31  Singing         Anna  
#>

您可以选择跳过多维数组，只使用单个数组，结果是相同的，然后转到用例的MS Excel部分。

Clear-Host
$Name  = @("John","Mary","Sarah") 
$Age   = @("23","44","31") 
$Hobby = @("Flying, Fishing","Dancing","Singing") 
$Kids  = @("Lucas","Simon, Lisa","Anna")

使用PowerShell ForEach方法和自定义对象。

$DataIndex = 0
$Name.ForEach(
    {
        (
            $MyDataObject = [PSCustomObject]@{
                Name  = $PSItem
                Age   = $Age[$DataIndex]
                Hobby = $Hobby[$DataIndex]
                Kids  = $Kids[$DataIndex]
            }    
        )
        
        $DataIndex++            
    }
)

# Results
<#
Name  Age Hobby           Kids       
----  --- -----           ----       
John  23  Flying, Fishing Lucas      
Mary  44  Dancing         Simon, Lisa
Sarah 31  Singing         Anna  
#>

MSExcel转换需要最终Csv输出

Clear-Host
$MDArrayData = @(
    @('John','Mary','Sarah'), 
    @('23','44','31'), 
    @('Flying, Fishing','Dancing','Singing'), 
    @('Lucas','Simon, Lisa','Anna')
)

0..(($MDArrayData[0]).Count -1) | 
ForEach-Object {
    (
        $MyDataObject = [PSCustomObject]@{
            Name  = $MDArrayData[0][$PSItem]
            Age   = $MDArrayData[1][$PSItem]
            Hobby = $MDArrayData[2][$PSItem]
            Kids  = $MDArrayData[3][$PSItem]
        }
    )
} | 
# Create or overwrite and existing report
Export-Csv -Path 'D:\Temp\FamilyReport.csv' -NoTypeInformation -Force

创建MSExcel COM对象以打开文件

Add-Type -AssemblyName Microsoft.Office.Interop.Excel
$Excel         = New-Object -ComObject excel.application
$Excel.Visible = $True

Open your report for formatting

$Workbook                = $Excel.workbooks.open('D:\Temp\FamilyReport.csv')
$Range                   = $Excel.Range("A:D")
$Range.VerticalAlignment = -4160
$Range.WrapText          = $True
$Range.EntireColumn.AutoFit()

1..4 | 
ForEach-Object {$Workbook.ActiveSheet.Cells.Item(1, $PSItem).Interior.ColorIndex = 15}

$Workbook.ActiveSheet.Cells.Item(1, 1).EntireRow.Font.Bold = $True

其他格式

$Workbook.ActiveSheet.ListObjects.Add(1, $range, $true)

你仍然必须记得清理你自己后面的所有东西示例化。又名GarbageCollection。