Powershell script that fetches a custom property field from Microsoft Excel document.

fetchExcelCustomField.ps1

$tmpPath = "C:\tmp\"
# $searchPath = "H:\Desktop"
$searchPath = (Get-Location).Path
$files = Get-ChildItem $searchPath -Recurse -Include *.xlsx
foreach ($f in $files){
	$filename = $f.FullName
	$guid = [guid]::NewGuid().Guid
	$tempname = $tmpPath + $guid + ".zip"
	$destinationUnarchivedPath = $tmpPath + $guid 
	$docProps = $destinationUnarchivedPath + "\docProps\custom.xml"
	if (Test-Path $filename) {
  		Copy-Item $filename $tempname -force
		Expand-Archive $tempname -DestinationPath $destinationUnarchivedPath
		Remove-Item $tempname -Force
		if (Test-Path $docProps) {
			$xml = [xml](Get-Content $docProps)
			$documentId = $xml.Properties.property | Where {$_.name -eq "documentId"} 
			$response = $documentId.r8
			Write-Output $response
		} 
		Remove-Item $destinationUnarchivedPath -Recurse -Force -Confirm:$false
	}
}