PSWriteExcel

0.0.15

Public/Get-ExcelProperties.ps1

function Get-ExcelProperties {
    param(
        [OfficeOpenXml.ExcelPackage] $ExcelDocument
    )
    if ($ExcelDocument) {
        $Properties = [ordered] @{}
        foreach ($Key in $ExcelDocument.Workbook.Properties.PsObject.Properties.Name | Where { $_ -notlike '*Xml'} ) {
            $Properties.$Key = $ExcelDocument.Workbook.Properties.$Key
        }
        return $Properties
    }
}