从sharepoint到python读取excel时的ValueError开发者社区

相关文章推荐

玩篮球的火锅 · What is the ...· 4 月前 ·

深情的围巾 · 现在的日本动画杀必死是不是比过去少了点？ ...· 4 月前 ·

儒雅的书包 · 高校贫困生资助体系- ...· 5 月前 ·

愤怒的卤蛋 · 高古玉赝品泛滥投资收藏须慎行_藏品沉淀_投资 ...· 7 月前 ·

威武的罐头 · 一台Win10掌机的诞生· 8 月前 ·

腾讯云

开发者社区

文档意见反馈控制台

首页 TVP

文章/答案/技术大牛

发布

https://company.sharepoint.com/:x:/s/project/letters-numbers?e=lettersnumbers

https://company.sharepoint.com/:x:/r/sites/project/_layouts/15/Doc.aspx?sourcedoc=letters-numbers&file=Table.xlsx&action=default&mobileredirect=true

import pandas as pd
from office365.runtime.auth.authentication_context import AuthenticationContext
from office365.sharepoint.client_context import ClientContext
from office365.sharepoint.files.file import File
URL = "https://company.sharepoint.com/:x:/s/project/letters-numbers?e=lettersnumbers"
USERNAME = "[email protected]"
PASSWORD = "abcd"
ctx_auth = AuthenticationContext(URL)
if ctx_auth.acquire_token_for_user(USERNAME, PASSWORD):
    ctx = ClientContext(URL, ctx_auth)
    web = ctx.web
    ctx.load(web)
    ctx.execute_query()
    print("Authentication successful")
else:
    print(ctx_auth.get_last_error())
response = File.open_binary(ctx, URL)
bytes_file_obj = io.BytesIO()
bytes_file_obj.write(response.content)
bytes_file_obj.seek(0)
df = pd.read_excel(bytes_file_obj, sheet_name="Sheet2")

ValueError: Excel file format cannot be determined, you must specify an engine manually.

URL = "https://company.sharepoint.com/:x:/r/sites/project"

RELATIVE_PATH = "/sites/project/Shared%20Documents/Folder/Table.xlsx"

ctx_auth = AuthenticationContext(URL)
if ctx_auth.acquire_token_for_user(USERNAME, PASSWORD):
    ctx = ClientContext(URL, ctx_auth)
    web = ctx.web
    ctx.load(web)
    ctx.execute_query()
    print("Authentication successful")
else:
    print(ctx_auth.get_last_error())

Stack Overflow用户