Opening hyperlinks inside Excel with Powershell

Question

I have a Excel sheet with about 600 rows with each row containing hyperlink to some downloadable file.

    #rowMax is the maxinum rows in the excel sheet
$rowMax = 99
$StartingColumnValue = 3
$StartingRowValue = 2
for ($StartingRowValue; $StartingRowValue -lt $rowMax+1; $StartingRowValue++){
    write-host $ExcelWorkSheet.Cells.Item($StartingRowValue,$StartingColumnValue).Text
}

So far I've managed to display the names of the hyperlinks, but I would like to actually "click" on them and download them.

How may I accomplish this? Thanks.

you can use the code on [How do i download a file using VBA (Without internet explorer)](https://stackoverflow.com/questions/17877389/how-do-i-download-a-file-using-vba-without-internet-explorer) and feed each link into it using a loop. — ShanayL, Sep 13 '17 at 00:17

score 1 · Answer 1 · answered Sep 13 '17 at 02:45

1

When you say you got the "name", I assume you got the link too.

Provided that it is the case, you could loop through the link and download them using the web client.

Here is a small example, extracting the filename from the URL (depending on the URL format, you might need to use another logic)

$WC = New-Object System.Net.WebClient 
$url = 'http://ec.ccm2.net/www.commentcamarche.net/download/files/SFDLC_v2.0_bin.zip'
$Filename = ($url.Split('/') | Select -Last 1)     

$wc.DownloadFile($url,"C:\__TMP\$Filename")

For alternative methods, take a look at this article.

If your file might be big and want some async method with progress, take a look at this gist

answered Sep 13 '17 at 02:45

Sage Pourpre

9,932
3
27
39

When I hover over my hyperlinks in the Excel sheet, a window pops up displaying the link(URL). How may I retrieve this URL using Powershell? – Cheng Lin Bi Sep 13 '17 at 14:24
I managed to find all the URLs of the hyperlinks, I will try this method. – Cheng Lin Bi Sep 13 '17 at 15:51
Thank you! This solution worked for me. Had to do a little bit of modification but your wc.DownloadFile() is what I wanted. – Cheng Lin Bi Sep 14 '17 at 15:52

Opening hyperlinks inside Excel with Powershell

1 Answers1