Read an Excel file which contains hyperlinks

Question

I need to read an excel file into R.

I am using the following code:

library(readxl)
data <- read_excel("path/to/file.xlsx")

The Excel file looks like this:

I would like to read the file into R so that the URLs behind the hyperlinks are also read into R. Currently, only the text is being read in, not the URLs.

So, the resulting data frame should look something like this:

print(data)

| id | link_text | link_url          |
|----|-----------|-------------------|
| 1  | link1     | www.google.com    |
| 2  | link2     | www.amazon.com    |
| 3  | link3     | www.bing.com      |
| 4  | link4     | www.apple.com     |
| 5  | link5     | www.microsoft.com |