时间戳

首页 > 解决方案 > 下载公共可访问链接共享点 Excel 文件

python - 下载公共可访问链接共享点 Excel 文件

问题描述

我正在尝试通过 python 下载一个公开可用的链接 SharePoint excel 文件。任何人都可以指导我如何访问和下载文件。已尝试过此操作，但出现“禁止”错误。

import pandas as pd
from urllib.request import urlopen
link = urlopen("https:/XXXX-my.sharepoint.com/:x:/g/personal/*****_onmicrosoft_com/cfdefjfnfefrnev?rtime=dvdfvdfCopy%20of%20PBI%20Forecast%20Phasing.xlsx/").read()


Full Error:



  File "C:\Users\Talha\Anaconda3\envs\spy\lib\urllib\request.py", line 755, in http_error_302
    return self.parent.open(new, timeout=req.timeout)

  File "C:\Users\Talha\Anaconda3\envs\spy\lib\urllib\request.py", line 531, in open
    response = meth(req, response)

  File "C:\Users\Talha\Anaconda3\envs\spy\lib\urllib\request.py", line 641, in http_response
    'http', request, response, code, msg, hdrs)

  File "C:\Users\Talha\Anaconda3\envs\spy\lib\urllib\request.py", line 569, in error
    return self._call_chain(*args)

  File "C:\Users\Talha\Anaconda3\envs\spy\lib\urllib\request.py", line 503, in _call_chain
    result = func(*args)

  File "C:\Users\Talha\Anaconda3\envs\spy\lib\urllib\request.py", line 649, in http_error_default
    raise HTTPError(req.full_url, code, msg, hdrs, fp)

HTTPError: Forbidden

标签： pythonpython-3.xsharepointurllib

解决方案

推荐阅读