print output of two commands in two columns in excel file

[melinadavid]

Hi,
I am writing a windows script to run 2 commands. Now the outputs goes in two rows, but I want the output of each command goes in different columns in excel. This is My script:

Code: Select all

For %%F in (*.txt) do ( 
Command_1 %%F >> output.xls & command_2 %%F >> output.xls
)

Now my Output.xls is like:

Code: Select all

AAA
BBB

I want my output.xls be like :

Code: Select all

AAA BBB      

I will appreciate if somebody has any solution for this.

Thanks,

[rednoah]

What you're trying to do is not possible with standard IO redirection. Moreover, use bash via WSL or PowerShell. You're doing yourself a disfavour by using CMD in this day and age.