If you really want to use for each, then open excel and just write %CurrentItem.Name% or %CurrentItem.NameWithoutExtension% directly to the cells. For instance, if you are putting them in column A…
set variable index=2 (assuming starting row 2)
launch excel
for each
Write to excel in column A and row %index%
set variable %index% to %index+1%
end for each
however, there is a much faster way to do this.
Run CMD for the folder you used in Get Files
write to cmd: dir /b | clip ‘this copies all filenames in the current directory to the clipboard.
Launch excel
activate the proper cell
paste from clipboard
’should be done
