由于某些原因，我无法获取工作簿中的工作表列表。这可能与我的另一个问题有关，即不能在excel表中添加记录
这是调用此端点时返回给我的完整错误消息：https://graph.microsoft.com/v1.0/sites/OurSiteId/drives/OurDriveId/Items/OurFileId/workbook/worksheets
{
"error": {
"code": "MaxRequestDurationExceeded",
"message": "We're sorry. We couldn't finish what you asked us to do because it was taking too long.",
"innerError": {
"code": "gatewayTimeoutUncategorized",
"message": "The service wasn't able to complete the request within the time limit.",
"innerError": {
"code": "MaxRequestDurationExceeded",
"message": "We're sorry. We couldn't finish what you asked us to do because it was taking too long."
},
"date": "2020-11-24T12:55:28",
"request-id": "c28bc40e-4ba6-4606-8c5a-ea0663cafa29",
"client-request-id": "c28bc40e-4ba6-4606-8c5a-ea0663cafa29"
}
}
}
在sharepoint中，工作簿的文件大小似乎有限制，但我正在处理的文件只有40mb(限制为50mb(，并且我已经遇到了文件访问问题。
我正在处理的文件已经有超过一百万条记录，这可能是问题的原因吗？
可能是这样，但请确保您可以在浏览器/onedrive中打开excel文件，然后手动编写信息。根据经验，确保它不包含任何样式、任何空单元格/列、任何宏等