[文件操作] 批处理如何遍历硬盘内的所有excel文件，并把xls格式改为xlsx格式

for /f "usebackq tokens=2 delims==" %%a in (`cmd /c "wmic logicaldisk get deviceid /value"`) do (
    for /f "usebackq tokens=2 delims==" %%a in (`dir /s /b %%a\*.xls`) do (
        ren "%%~a" "%%~na.xlsx"
    )
)
复制代码

@cd /d %~dp0 & powershell -command "Get-Content '%~0' | Select-Object -Skip 1 | Out-String | Invoke-Expression" & pause & exit/b

 [System.Environment]::GetLogicalDrives() | foreach-object {
    Get-ChildItem -path $_ -Include *.xls -Recurse | foreach-object {
        Rename-Item $_.FullName -NewName ($_.fullname -replace ".xls$",".xlsx")
    }
复制代码