假设文本文件和易表文件存放于同一目录,文本文件名称为“A”
ClearGrid(grid) and
ImportTextFile(docdir+"A.txt",char(9),char(13),0) And DelFor(grid,1,"=","") and
evalfor(grid,2,"if(row<=-int(-rows/6),cell(-int(-rows/6)+row,1),"""")") and
evalfor(grid,3,"if(row<=-int(-rows/6),cell(-int(-rows/6)*2+row,1),"""")") and
evalfor(grid,4,"if(row<=-int(-rows/6),cell(-int(-rows/6)*3+row,1),"""")") and
evalfor(grid,5,"if(row<=-int(-rows/6),cell(-int(-rows/6)*4+row,1),"""")") and
evalfor(grid,6,"if(row<=-int(-rows/6),cell(-int(-rows/6)*5+row,1),"""")") and
DelFor(grid,2,"=","") and ExportTextFile(docdir+"B.txt",char(9),char(13),grid)