download files on internet from url in excel sheet

Discussion forum for all Windows batch related topics.

Moderator: DosItHelp

Post Reply
Message
Author
G33kman
Posts: 1
Joined: 03 Aug 2012 10:58

download files on internet from url in excel sheet

#1 Post by G33kman » 03 Aug 2012 11:15

Ok so I'm trying to create a batch file to pull a url from an excel sheet and than download the file from a server
I.e.
Find url in excel sheet
Go to address and download file
Go to next url
Download file.
I don't know if I'm explaining this right I've been throwing this around in my head the last two days and it's got me stumped.
I'm guessing I'm going to have to use some kind of four statement but that's all i got...
Any help would be greatly appreciated!
If you need any more info just let me know.

foxidrive
Expert
Posts: 6031
Joined: 10 Feb 2012 02:20

Re: download files on internet from url in excel sheet

#2 Post by foxidrive » 03 Aug 2012 12:09

Do you know where the URL is?

Or does the spreadsheet contain loads of info including URLs?

Can you give us an example of the spreadsheet when saved to CSV format?

Squashman
Expert
Posts: 4488
Joined: 23 Dec 2011 13:59

Re: download files on internet from url in excel sheet

#3 Post by Squashman » 03 Aug 2012 13:43

Powershell can read from an excel spreadsheet, I would assume vbscript can as well. Batch cannot read directly from an excel file. As Foxidrive has implied you need to export it as a CSV first if you want to do this with a batch file.

Post Reply