批处理文件：依据参数表.xlsx精准修改文件.txt中p、t、s值

:a1] 2000mm/sec cnt100 spot[sd=1,p=10,t=2.0,s=100,ed=1]; 2:l p[57:a2] 2000mm/sec cnt100 spot[sd=1,p=20,t=2.0,s=101,ed=1]; 3:l p[67:a3] 2000mm/sec cnt100 spot[sd=1,p=30,t=2.0,s=102,ed=1]; 以下是批处理文件的内容： @echo off setlocal enabledelayedexpansion set "xlsx=参数表.xlsx" set "txt=文件.txt" for /f "tokens=1-3 delims=: " %%a in ('findstr /n "^" "%txt%"') do ( set "line=%%b" set "p=" set "t=" set "s=" for /f "tokens=1,2,3 delims=:[] " %%i in ("!line!") do ( if "%%i"=="p" ( set "p=%%k" ) else if "%%i"=="t" ( set "t=%%k" ) else if "%%i"=="s" ( set "s=%%k" ) ) for /f "tokens=1,3 delims=," %%x in ('type "%xlsx%" ^| findstr /b /e /c:"%%b,"') do ( set "a=%%x" set "c=%%y" for /f "tokens=2 delims=:" %%z in ("!c!") do set "c=%%z" ) for /f "tokens=1,3 delims=," %%x in ('type "%xlsx%" ^| findstr /b /e /c:"%%b,"') do ( set "a=%%x" set "d=%%z" ) set "line=!line:p=%c%!" set "line=!line:t=%a%!" set "line=!line:s=%d%!" echo !line!>>"temp.txt" ) move /y "temp.txt" "%txt%" echo 批处理文件执行完毕。 pause 注意：请将批处理文件和参数表.xlsx和文件.txt放在同一个文件夹下执行批处理。执行完毕后，文件.txt会被修改。 ######[AI写代码神器 | 811点数解答 | 2024-12-05 12:58:37]