Batch file that takes rows from excel

[ColdAsIce]

How would I go about creating a batch file that takes rows from excel.

for example:

Username, Password

I want the 900 odd names and passwords redirected to a folder on my desktop.

So I would get 900 individual files with the username as the name of the file and inside would be the username and password.

 

[philjohn]

How would I go about creating a batch file that takes rows from excel.

for example:

Username, Password

I want the 900 odd names and passwords redirected to a folder on my desktop.

So I would get 900 individual files with the username as the name of the file and inside would be the username and password.

I don't know if it's possible from an actual Excel file, but you can export as CSV (a text file where the values are all separated by commas) and try parsing that somehow, you may need some unixy utilities like sed to help (you can get them from the cygwin project).

 

[ColdAsIce]

I figured it would have to go from excel into a txt file of some sort but I cannot find a way to get the desired output