搞了个模拟的(如果楼主仔细想一下,就可以根据这个代码来解决自己问题):- @echo off&setlocal enabledelayedexpansion
- (for %%a in (a b c d e f g h i j) do (
- for /l %%b in (1,1,1000) do set /p=%%a<nul
- ))>temp.xls&echo.>>temp.xls
- (for /l %%a in (1,1,25) do (
- set /a "n=400*(%%a-1)+1"
- echo =mid^(a1,!n!,400^)^&^"\^"
- ))>>temp.xls
- start temp.xls
复制代码 下面是分隔后合到一行的(复制temp.xls第二行粘贴到txt文本中看),真难搞- @echo off&setlocal enabledelayedexpansion
- (for %%a in (a b c d e f g h i j) do (
- for /l %%b in (1,1,1000) do set /p=%%a<nul
- ))>temp.xls&echo.>>temp.xls
- for /l %%a in (1,1,25) do (
- set /a "n=400*(%%a-1)+1
- set str=!str!^&mid^(a1,!n!,400^)^&^"\^"
- )
- echo =!str:~1!>>temp.xls
- start temp.xls
复制代码
[ 本帖最后由 batman 于 2010-11-27 11:59 编辑 ] |