Download multiple excel files linked through urls in R

0 votes

I have a list containing hundreds of URLs directly linking to .xlsx files for a download:

list <- c("https://ec.europa.eu/consumers/consumers_safety/safety_products/rapex/alerts/?event=main.weeklyReport.Excel&web_report_id=980", 
          "https://ec.europa.eu/consumers/consumers_safety/safety_products/rapex/alerts/?event=main.weeklyReport.Excel&web_report_id=981", 
          "https://ec.europa.eu/consumers/consumers_safety/safety_products/rapex/alerts/?event=main.weeklyReport.Excel&web_report_id=990")

To download everything in the list, I created a loop:

for (url in list) {
  download.file(url, destfile = "Rapex-Publication.xlsx", mode="wb")
}

However, it only downloads the first file and not the rest. My guess is that the program is overwriting the same destfile. What would I have to do to circumvent this issue?

Sep 22 in Others by Kithuzzz
• 20,660 points
80 views

1 answer to this question.

0 votes

Try something along the lines of:

for (i in 1:length(list)) {
  download.file(list[i], destfile = paste0("Rapex-Publication-", i, ".xlsx"),  mode="wb")
}
answered Sep 23 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

How to open .xlsx files in MS Excel from VS Code?

Hello, to open xlxs files, or files ...READ MORE

answered Feb 17 in Others by gaurav
• 22,040 points
233 views
0 votes
0 answers

Importing Excel files into R, xlsx or xls

Please can someone help me on the ...READ MORE

Jun 13 in Others by Avinash
• 1,260 points
43 views
0 votes
1 answer
0 votes
1 answer

Print chosen worksheets in excel files to pdf in python

In the simplest form: import win32com.client o = win32com.client.Dispatch("Excel.Application") o.Visible ...READ MORE

answered Sep 24 in Others by narikkadan
• 37,660 points
203 views
0 votes
1 answer

Excel, How to split cells by comma delimiter into new cells

The Excel manual method: choose Text to Column ...READ MORE

answered Oct 3 in Others by narikkadan
• 37,660 points
66 views
0 votes
1 answer

Conversion of PDF file to Excel in R

I looked at the pdf, and it ...READ MORE

answered Oct 16 in Others by narikkadan
• 37,660 points
62 views
0 votes
1 answer

Use R to create chart in Excel sheet

Here is a solution utilizing the XLConnect ...READ MORE

answered Nov 10 in Others by narikkadan
• 37,660 points
26 views
0 votes
1 answer

Write from R into template in excel while preserving formatting

you have the XLConnect package. Read the documentation or the vignette of that ...READ MORE

answered Nov 10 in Others by narikkadan
• 37,660 points
39 views
0 votes
1 answer

Comparing two Excel files in R and returning different titles

Solution: library(tidyverse) dat <- read_xlsx("Book1.xlsx") dat2 <- read_xlsx("Book2.xlsx") book1_output <- anti_join(dat,dat2, ...READ MORE

answered Oct 14 in Others by narikkadan
• 37,660 points
63 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP