为何PowerShell脚本命令行运行正常，Java调用却无效果？

问题背景 #

直接在PowerShell中执行以下命令可成功将XLSX文件转换为CSV：

powershell.exe -ExecutionPolicy Unrestricted -file 'C:\Users\xxxyyy\Downloads\test_script.ps1' -d 'C:\Users\xxxyyy\Downloads' -f 'TestFile'

但使用下方Java测试类调用时，测试通过却未生成目标CSV文件。

原始代码 #

Java测试类 #

import org.junit.jupiter.api.Test;

import java.io.*;
import java.nio.charset.StandardCharsets;

public class PowershellTest {

     @Test
     public void shouldConvertXlsxToCsv() {
        try {
            runCommand();
         } catch (IOException e) {
             e.printStackTrace();
         }
     }

    public void runCommand() throws IOException {
         String[] command = new String[]{"powershell.exe","-ExecutionPolicy Unrestricted -file 'C:\\Users\\xxxyyy\\Downloads\\test_script.ps1' -d 'C:\\Users\\xxxyyy\\Downloads' -f 'TestFile'"};
         Process powerShellProcess = Runtime.getRuntime().exec(command);
         powerShellProcess.getOutputStream().close();
         BufferedReader output = new BufferedReader(new 
         InputStreamReader(powerShellProcess.getInputStream(), StandardCharsets.ISO_8859_1));

         try {
            String line;
            while ((line = output.readLine()) != null) {
                System.out.println(line);
            }
        } catch (Exception e) {
           throw new RuntimeException(e);
        } finally {
            try {
                output.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }
}

PowerShell脚本 #

Param(
    [string]$d,
    [string]$f
) 

$excelFile = $d + '\' + $f + ".xlsx"
$Excel = New-Object -ComObject Excel.Application
$wb = $Excel.Workbooks.Open($excelFile)

foreach ($ws in $wb.Worksheets) {
    $ws.SaveAs($d + '\' + $f + ".csv", 6)
}
$Excel.Quit()

问题原因及解决办法 #

1. Java命令参数拆分错误 #

Runtime.exec()要求每个命令参数作为数组的独立元素，原代码将所有参数合并为一个字符串，导致PowerShell无法正确解析。

修正后的命令数组：

String[] command = new String[]{
    "powershell.exe",
    "-ExecutionPolicy", "Unrestricted",
    "-file", "C:\\Users\\xxxyyy\\Downloads\\test_script.ps1",
    "-d", "C:\\Users\\xxxyyy\\Downloads",
    "-f", "TestFile"
};

注意：路径不需要额外加单引号，数组元素会被作为独立参数传递，PowerShell能正确识别带空格的路径。

2. 未读取错误输出 #

原代码只读取了标准输出，PowerShell的错误信息会输出到错误流，导致无法排查脚本执行失败的原因。需添加错误流读取：

添加错误流处理：

// 读取错误输出
BufferedReader errorOutput = new BufferedReader(
    new InputStreamReader(powerShellProcess.getErrorStream(), StandardCharsets.ISO_8859_1)
);
// 启动线程读取错误流，避免进程阻塞
new Thread(() -> {
    String line;
    try {
        while ((line = errorOutput.readLine()) != null) {
            System.err.println("PowerShell错误输出：" + line);
        }
    } catch (IOException e) {
        e.printStackTrace();
    } finally {
        try {
            errorOutput.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}).start();

3. 未等待进程执行完成 #

原代码启动进程后直接读取输出，可能在脚本执行完成前就结束了，需等待进程执行完毕：

添加进程等待：

try {
    int exitCode = powerShellProcess.waitFor();
    System.out.println("PowerShell进程退出码：" + exitCode);
} catch (InterruptedException e) {
    e.printStackTrace();
}

4. PowerShell脚本优化（避免Excel进程残留） #

原脚本未释放COM对象，可能导致Excel进程在后台残留，无法完成文件保存。需添加COM对象释放逻辑：

优化后的PowerShell脚本：

Param(
    [string]$d,
    [string]$f
) 

$excelFile = Join-Path -Path $d -ChildPath "$f.xlsx"
$Excel = New-Object -ComObject Excel.Application
$Excel.Visible = $false # 隐藏Excel窗口，避免交互
$wb = $Excel.Workbooks.Open($excelFile)

foreach ($ws in $wb.Worksheets) {
    $csvPath = Join-Path -Path $d -ChildPath "$f.csv"
    $ws.SaveAs($csvPath, 6)
}

$wb.Close()
$Excel.Quit()
# 释放COM对象
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($wb) | Out-Null
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($Excel) | Out-Null
[System.GC]::Collect()
[System.GC]::WaitForPendingFinalizers()

完整修正后的Java代码 #

import org.junit.jupiter.api.Test;

import java.io.*;
import java.nio.charset.StandardCharsets;

public class PowershellTest {

    @Test
    public void shouldConvertXlsxToCsv() {
        try {
            runCommand();
        } catch (IOException | InterruptedException e) {
            e.printStackTrace();
        }
    }

    public void runCommand() throws IOException, InterruptedException {
        String[] command = new String[]{
                "powershell.exe",
                "-ExecutionPolicy", "Unrestricted",
                "-file", "C:\\Users\\xxxyyy\\Downloads\\test_script.ps1",
                "-d", "C:\\Users\\xxxyyy\\Downloads",
                "-f", "TestFile"
        };
        Process powerShellProcess = Runtime.getRuntime().exec(command);
        powerShellProcess.getOutputStream().close();

        // 读取标准输出
        BufferedReader output = new BufferedReader(
                new InputStreamReader(powerShellProcess.getInputStream(), StandardCharsets.ISO_8859_1)
        );

        // 读取错误输出
        BufferedReader errorOutput = new BufferedReader(
                new InputStreamReader(powerShellProcess.getErrorStream(), StandardCharsets.ISO_8859_1)
        );

        // 启动线程读取错误流
        new Thread(() -> {
            String line;
            try {
                while ((line = errorOutput.readLine()) != null) {
                    System.err.println("PowerShell错误输出：" + line);
                }
            } catch (IOException e) {
                e.printStackTrace();
            } finally {
                try {
                    errorOutput.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
        }).start();

        try {
            String line;
            while ((line = output.readLine()) != null) {
                System.out.println("PowerShell标准输出：" + line);
            }

            // 等待进程执行完成
            int exitCode = powerShellProcess.waitFor();
            System.out.println("PowerShell进程退出码：" + exitCode);
        } catch (Exception e) {
            throw new RuntimeException(e);
        } finally {
            try {
                output.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }
}

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