Downloading and saving Excel files using Matlab

14 次查看（过去 30 天）
Joanna Przeworska
Joanna Przeworska 2021-5-18
评论： Joanna Przeworska 2021-5-20
I would like to download this file: https://www.nbp.pl/en/statystyka/m3/podaz_bilansowa_en.xlsx and save it in the folder, all using Matlab. Is there any way I can do this? I red about 'urlread' and 'urlwrite' however do not know how exactly use it for my purpose.
  5 个评论
显示 3更早的评论
Joanna Przeworska
Joanna Przeworska 2021-5-18
Unfortunately it returns error as well...
Error using matlab.internal.webservices.HTTPConnector/copyContentToFile (line 412)
The server returned the status 403 with message "Forbidden" in response to the request to URL
https://www.nbp.pl/en/statystyka/m3/.
Error in websave (line 107)
copyContentToFile(connection, filename);

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Rik
Rik 2021-5-18
It seems this website blocks requests when it detects non-human requests.
You might be able to circumvent this by use the Wayback Machine. I have found that on some occasions that will work.
If you want an easy way to interact with the Wayback Machine from Matlab, you can get my WBM function from the FEX.
WBM(filename,fullURL);
  14 个评论
显示 12更早的评论
Rik
Rik 2021-5-19
If your IT department policy even disables reaching out to archive.org, you should ask them for suggestions.
If you have such a strict environment, why do you want to dynamically load a file from the internet anyway?
Joanna Przeworska
Joanna Przeworska 2021-5-20
To be honest I didn't know it was that strict. I was hoping there was a solution. Anyway, I'm really grateful for the time you took to help me.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Downloads 的更多信息

标签

产品


版本

R2019b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by