批处理脚本 - 在目录中的每个文件运行命令 [英] batch script - run command on each file in directory
问题描述
我需要一些XLS文件转换成XLSX文件。我可以成功地将一个xls文件到XLSX运行以下命令到CMD提示符(Windows):
ssconvert inputFileName.xls outputFileName.xlsx
(ssconvert是的Gnumeric的命令行实用工具,可以不同的S preadsheet文件格式之间进行转换)
我想编写一个批处理文件,对于在指定目录中的每个文件运行我上面写的,用当前的文件名都为输入和输出文件名。
命令例如,如果我有这样的文件集:
C:\\目录\\ file1.xls
C:\\目录\\ file2.xls
C:\\目录\\ file3.xls
输出应为
C:\\目录\\ file1.xlsx
C:\\目录\\ file2.xlsx
C:\\目录\\ file3.xlsx
这样一批伪code应该是这样
目录= C:\\目录\\
对于(目录文件名)
ssconvert fileName.xls fileName.xlsx
谁能帮我?
在/ R %% V(的* .xls)做ssconvert%% V%% VX
I need to convert some xls files into xlsx files. I can successfully convert one xls file into xlsx by running this command into cmd prompt (windows):
ssconvert inputFileName.xls outputFileName.xlsx
(ssconvert is a Gnumeric's command-line utility that can convert between different spreadsheet file formats)
I'd like to write a batch file that FOR EACH file in a specified directory runs the command I wrote above, using the current file name both for input and for output filename.
For example, if I have this set of files:
c:\directory\file1.xls
c:\directory\file2.xls
c:\directory\file3.xls
the output should be
c:\directory\file1.xlsx
c:\directory\file2.xlsx
c:\directory\file3.xlsx
so the batch pseudo code should be something like
directory = c:\directory\
for (fileName in directory)
ssconvert fileName.xls fileName.xlsx
Can anyone help me?
for /r %%v in (*.xls) do ssconvert "%%v" "%%vx"
这篇关于批处理脚本 - 在目录中的每个文件运行命令的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!