问从Excel导出图表

EN

$package = Export-Excel -InputObject $data -Path $filename  -TableName Xyz -ExcelChartDefinition $c -AutoNameRange -PassThru
Write-Host "Package is " $package.ToString()

$wb = $package.Workbook
Write-Host "Workbook is " $wb.ToString()

foreach ($ws in $wb.Worksheets) {
    Write-Host "Worksheet is " $ws.ToString()
    foreach ($excelchart in $ws.Drawings)  {
        Write-Host "Chart is " $excelchart.ToString()
    }
}

Package is  OfficeOpenXml.ExcelPackage
Workbook is  OfficeOpenXml.ExcelWorkbook
Worksheet is  Sheet1
Chart is  OfficeOpenXml.Drawing.Chart.ExcelBarChart