PowerShell脚本检查Python版本架构及Excel适配问题求助

Fixing the "Cannot call method on null expression" Error #

The error occurs because where.exe python returns no results if Python isn't installed, leading to a null value when you attempt to process paths. Add a check to handle empty outputs:

$pythonPaths = where.exe python 2>$null
if (-not $pythonPaths) {
    Write-Host "No Python installations detected."
    # Proceed to installation logic
} else {
    foreach ($path in $pythonPaths) {
        # Process each Python executable path
    }
}

Explanation: Redirecting stderr to null (2>$null) suppresses error messages when Python isn't found, and the explicit check for empty $pythonPaths prevents null reference errors.

Extracting Version and Architecture from Python Output #

Use regex to parse the output of python -VV reliably:

foreach ($path in $pythonPaths) {
    $versionOutput = & $path -VV 2>&1 | Out-String
    
    # Extract version number (e.g., 3.9.12)
    $versionMatch = [regex]::Match($versionOutput, 'Python (\d+\.\d+\.\d+)')
    $pythonVersion = $versionMatch.Success ? $versionMatch.Groups[1].Value : $null
    
    # Extract architecture (64-bit/32-bit)
    $archMatch = [regex]::Match($versionOutput, '(\d+ bit) \((AMD64|x86)\)')
    $pythonArch = if ($archMatch.Success) {
        $archMatch.Groups[2].Value -eq 'AMD64' ? '64-bit' : '32-bit'
    } else { $null }

    Write-Host "Found Python $pythonVersion ($pythonArch) at $path"
}

Explanation: The regex patterns target specific sections of the version output, and we verify match success to avoid invalid null values.

Implementing the Full Workflow #

Step 1: Detect System Architecture #

$systemArch = [Environment]::Is64BitOperatingSystem ? '64-bit' : '32-bit'

Step 2: Check Excel Installation and Architecture #

Query the Windows registry to find Excel's install path and architecture:

function Get-ExcelArchitecture {
    $registryPaths = @(
        'HKLM:\SOFTWARE\Microsoft\Office\*\Excel\InstallRoot',
        'HKLM:\SOFTWARE\Wow6432Node\Microsoft\Office\*\Excel\InstallRoot'
    )
    foreach ($regPath in $registryPaths) {
        $installProps = Get-ItemProperty -Path $regPath -Name Path -ErrorAction SilentlyContinue
        if ($installProps) {
            $excelExe = Join-Path $installProps.Path 'EXCEL.EXE'
            if (Test-Path $excelExe) {
                $fileInfo = Get-Item $excelExe
                return $fileInfo.Is64Bit ? '64-bit' : '32-bit'
            }
        }
    }
    return $null # Excel not installed
}

$excelArch = Get-ExcelArchitecture

Step 3: Execute Platform-Specific Logic #

64-bit System Logic

if ($systemArch -eq '64-bit') {
    if (-not $excelArch) {
        Write-Host "Excel not installed. Installing 64-bit Excel first..."
        # Add code to trigger 64-bit Excel installation (e.g., silent MSI execution)
        $excelArch = Get-ExcelArchitecture # Re-check after installation
    }

    # Find Python matching Excel's architecture
    $matchingPython = $pythonPaths | ForEach-Object {
        $path = $_
        $versionOutput = & $path -VV 2>&1 | Out-String
        $archMatch = [regex]::Match($versionOutput, '\((AMD64|x86)\)')
        if ($archMatch.Success) {
            $arch = $archMatch.Groups[1].Value -eq 'AMD64' ? '64-bit' : '32-bit'
            if ($arch -eq $excelArch) { return $path }
        }
    }

    if (-not $matchingPython) {
        Write-Host "No $excelArch Python detected. Installing $excelArch Python..."
        # Add silent Python installation logic (e.g., `python-installer.exe /quiet InstallAllUsers=1 PrependPath=1`)
    } else {
        Write-Host "Found matching $excelArch Python at $matchingPython"
    }
}

32-bit System Logic

else {
    if (-not $excelArch) {
        Write-Host "Excel not installed. Installing 32-bit Python..."
        # Add 32-bit Python silent installation logic
    } else {
        # Verify 32-bit Python exists
        $has32BitPython = $pythonPaths | ForEach-Object {
            $versionOutput = & $_ -VV 2>&1 | Out-String
            [regex]::Match($versionOutput, '\(x86\)').Success
        }
        if (-not $has32BitPython) {
            Write-Host "No 32-bit Python detected. Installing..."
            # Add 32-bit Python silent installation logic
        }
    }
}

Key Notes #

• For silent Python installations, use official installer arguments like /quiet InstallAllUsers=1 PrependPath=1
• Adjust Excel installation logic to match your deployment method (MSI, Click-to-Run, etc.)

内容的提问来源于stack exchange，提问作者Aniss Chohra