terse

这部分改一下试呢

for /f "delims=" %%a in ('dir /a-d/s/b *.lvm') do (
    set n=0&set/a m+=1
    for /f "tokens=3" %%b in ('type "%%a"') do (
    set/a n+=1&set str!m!_!n!=%%b
    )
)
(for /l %%a in (1 1 !n!) do (
    for /l %%b in (1 1 !m!) do (
    set/p=!str%%b_%%a! <nul
    )
echo.
))>new.lvm
复制代码

terse

这里应该也不能改，放到后面吧  ren new.csv new.xlsx

这样生成csv文件呢

@echo off&setlocal enabledelayedexpansion
for /f "delims=" %%a in ('dir /a-d/s/b *.lvm') do (
     set n=0
     for /f "usebackq tokens=3" %%b in ("%%a") do (
          set/a n+=1
          for %%c in (!n!) do set _!n!=!_%%c! %%b
     )
)

(for /l %%a in (8,1,!n!) do (
      set "str="
      for %%b in (!_%%a!) do (
           set s=%%b
           if "!s:~,1!" == "-" (set t=-&set "s=!s:~1!") else set "t="
           for /f "delims=.0123456789" %%c in ("!s!") do set "s="
           if defined s set str=!str!,!t!!s!
      )
      echo!str!
))>new.csv

pause
复制代码

terse

不清楚里那边没成功的原因，关掉回显试呢 我这里运行正常的，图片传不上

0.021841,0.034476,0.057524,0.021841,0.034476,0.037996,0.026896,0.017917,0.016473,0.046873,0.021037,0.066235,0.021384,0.041630,0.070698
0.019911,0.032562,0.055642,0.019911,0.032562,0.036256,0.025116,0.016234,0.014831,0.044821,0.019360,0.064212,0.019452,0.039908,0.069087
0.017951,0.030625,0.053731,0.017951,0.030625,0.034484,0.023288,0.014520,0.013140,0.042733,0.017666,0.062174,0.017484,0.038172,0.067416
0.016004,0.028708,0.051819,0.016004,0.028708,0.032702,0.021456,0.012811,0.011469,0.040664,0.015969,0.060117,0.015515,0.036426,0.065790
0.014071,0.026792,0.049911,0.014071,0.026792,0.030952,0.019674,0.011120,0.009805,0.038591,0.014306,0.058073,0.013550,0.034686,0.064145
0.012078,0.024837,0.047972,0.012078,0.024837,0.029164,0.017823,0.009389,0.008116,0.036497,0.012603,0.056005,0.011563,0.032951,0.062466
复制代码