Read Excel-file from sftp server

Question

I would like to read an .xlsx-File from a password protected ftp-Server into my R.

With getURL I'm able to address the files and get their names, for example "sftp://datasource.eex-group.com/market_data/power/ch/derivatives/xls/2023/PowerFutureHistory_CH_2023.xlsx", but then I don't know how to read/import this xlsx-file into R.

Is it a problem, if the path name has a blank, e.g. "sftp://datasource.eex-group.com/market data/power/ch/derivatives/xls/2023/PowerFutureHistory_CH_2023.xlsx"

I see no blanks, do you mean if your `"_"` is really a space `" "`? — r2evans, May 10 '23 at 15:17
It might help to see the code you're using to retrieve the files from the sftp site. — r2evans, May 10 '23 at 15:18
First thing: can you verify that non-R tools can access and download the files in question? — Carl Witthoft, May 10 '23 at 15:20

MPB_2022 · Accepted Answer · 2023-05-26T08:22:51.013

0

Thanks for the comments.

I found the answer on Reading information from a password protected site for the password protected part and How to simply download an Excel File directly from the Internet with R for downloading the excel/csv-file.

In combination it works perfectly.

url = "sftp://user:passwd@server:port"

file.server <- paste0(url, path.server, "Excelfile_name_server.xlsx")

file.local <- paste0(path.local, "Excelfile_name_local.xlsx")

download.file(file.server, destfile = file.local, mode = "wb")

edited May 26 '23 at 08:22

answered May 26 '23 at 07:06

MPB_2022

67
4

https://meta.stackexchange.com/a/8259/997587 – starball May 26 '23 at 07:33

Read Excel-file from sftp server

1 Answers1