MS Graph 更新设置单元格中的 Excel 值

使用 MS Graph 更新/设置单元格中的 Excel 值

python
import requests
import json
# 定义要更新的单元格值
cell_value = "Hello, World!"
# 定义要更新的单元格地址
cell_address = "Sheet1!A1"
# 定义请求的 URL
url = "https://graph.microsoft.com/v1.0/me/drive/items/{item-id}/workbook/worksheets/{worksheet-id}/range(address='{address}')"
# 替换 URL 中的参数
url = url.replace("{item-id}", "your-item-id")
url = url.replace("{worksheet-id}", "your-worksheet-id")
url = url.replace("{address}", cell_address)
# 定义请求头部
headers = {
    "Authorization": "Bearer {access-token}",
    "Content-Type": "application/json"
}
# 定义请求体
data = {
    "values": [[cell_value]]
}
# 发送请求
response = requests.patch(url, headers=headers, data=json.dumps(data))
# 处理响应
if response.status_code == 200:
    print("单元格值更新成功！")
else:
    print("单元格值更新失败！")

python
import requests
import json
# 定义要设置的单元格值
cell_value = "Hello, World!"
# 定义要设置的单元格地址
cell_address = "Sheet1!A1"
# 定义请求的 URL
url = "https://graph.microsoft.com/v1.0/me/drive/items/{item-id}/workbook/worksheets/{worksheet-id}/range(address='{address}')"
# 替换 URL 中的参数
url = url.replace("{item-id}", "your-item-id")
url = url.replace("{worksheet-id}", "your-worksheet-id")
url = url.replace("{address}", cell_address)
# 定义请求头部
headers = {
    "Authorization": "Bearer {access-token}",
    "Content-Type": "application/json"
}
# 定义请求体
data = {
    "values": [[cell_value]]
}
# 发送请求
response = requests.put(url, headers=headers, data=json.dumps(data))
# 处理响应
if response.status_code == 201:
    print("单元格值设置成功！")
else:
    print("单元格值设置失败！")