batch script - run command on each file in directory

Question

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

User · Answer

Actually this is pretty easy since Windows Vista. Microsoft added the command FORFILES

in your case

forfiles /p c:\directory /m *.xls /c "cmd /c ssconvert @file @fname.xlsx"

the only weird thing with this command is that forfiles automatically adds double quotes around @file and @fname. but it should work anyway

User · Answer

you can run something like this  paste the code bellow in a  bat  or if you want it to run interractively replace the    by      for   i in  c  directory   xls  do ssconvert   i   i xlsx   If you can run powershell it will be    Get-ChildItem -Path c  directory -filter   xls   foreach  ssconvert      FullName       baseName  xlsx

User · Answer

I am doing similar thing to compile all the c files in a directory   for iterating files in different directory try this    set codedirectory C  Users code for  r   codedirectory    i in    c  do    some GCC commands

User · Answer

for  r   v in    xls  do ssconvert    v     vx    a couple have people have asked me to explain this  so   Part 1  for  r   v in    xls   This part returns an array of files in the current directory that have the xls extension  The    may look a little curious  This is basically the special   character from command line as used in  PATH  or  TEMP   To use it in a batch file we need to escape it like so    PATH   or   TEMP    In this case we are simply escaping the temporary variable v  which will hold our array of filenames   We are using the  r switch to search for files recursively  so any matching files in child folders will also be located   Part 2  do ssconvert    v     vx   This second part is what will get executed once per matching filename  so if the following files were present in the current folder   c  temp mySheet xls   c  temp mySheet yesterday xls  c  temp mySheet 20160902 xls   the following commands would be executed   ssconvert  c  temp mySheet xls   c  temp mySheet xlsx  ssconvert  c  temp mySheet yesterday xls   c  temp mySheet yesterday xlsx  ssconvert  c  temp mySheet 20160902 xls   c  temp mySheet 20160902 xlsx

[batch-file] batch script - run command on each file in directory

Examples related to batch-file

Examples related to cmd

Examples related to foreach

Examples related to ssconvert