python - 如何使用python脚本打印一行今天日期的excel表？

Question

我正在编写一个代码，以使用今天的日期在 Excel 表中打印该行。这是表格的外观模型。

日期 日 列 1 列 2 列 3

1 星期一价值价值价值

如果今天的日期是 1/anymonth/anyyear 我想打印该特定行。[1 Monday Value Value Value]

下面是我打印整张纸的python代码

from office365.runtime.auth.authentication_context import AuthenticationContext
from office365.sharepoint.client_context import ClientContext
from office365.sharepoint.files.file import File
import xlrd
import io
import pandas as pd
#target url taken from sharepoint and credentials
url = 'https://epiuse-my.sharepoint.com/:x:/r/personal/xxx/Documents/xxx%20xxx%xxx%20xxx%202021.xlsx?'
username = 'email id'
password = 'password'
relative_url = 'personal/xxx/_layouts/15/Doc.aspx?sourcedoc=%7B765306EC-3217-4BC1-B32C-689C5B4B1F2B%7D&file=xxx%202021.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")
filename = 'xxx%20xxx%xxx%20xxx%202021.xlsx'
with open(filename, 'wb') as output_file:
    response = File.open_binary(ctx, relative_url)
    output_file.write(response.content)
response = File.open_binary(ctx, relative_url)
#save data to BytesIO stream
bytes_file_obj = io.BytesIO()
bytes_file_obj.write(response.content)
bytes_file_obj.seek(0) #set file object to start
#read file into pandas dataframe
df = pd.read_excel(bytes_file_obj)
print(df)

标签： pythonpython-3.xexcelpandas