我想使用 Microsoft Graph REST API 访问/操作存储在 OneDrive Personal 中的 Excel 工作簿.我能够访问/操作存储在 OneDrive for Business 中的 Excel 工作簿.

I would like to access/manipulate Excel workbooks stored in OneDrive Personal using the Microsoft Graph REST API. I am able to access/manipulate Excel workbooks stored in OneDrive for Business.

我能够验证我的 OneDrive 个人帐户(获取访问令牌、权限范围等)并且我能够执行其他(非 Excel 相关的)Graph REST 操作，例如查看文件属性.

I am able to authenticate my OneDrive Personal account (get access tokens, permission scopes, etc.) and I am able to do other (non-Excel-related) Graph REST operations, such as view file properties.

Microsoft Graph Explorer https://graph.microsoft.io/en-us/graph-explorer# 仅支持 OneDrive for Business(不支持 OneDrive Personal).

The Microsoft Graph Explorer https://graph.microsoft.io/en-us/graph-explorer# only supports OneDrive for Business (not OneDrive Personal).

这里 https://graph.microsoft.io/en-us/docs/api-reference/v1.0/resources/excel，它说……读取和修改存储在 OneDrive、SharePoint 或其他支持的存储平台中的 Excel 工作簿".它们真的是指OneDrive for Business"吗?

Here https://graph.microsoft.io/en-us/docs/api-reference/v1.0/resources/excel, it says "…read and modify Excel workbooks stored in OneDrive, SharePoint, or other supported storage platforms". Could they really mean "OneDrive for Business"?

当我尝试访问任何与 Excel 工作簿相关的内容(在 OneDrive Personal 上)时，例如:

When I try to access anything Excel-workbook-related (on OneDrive Personal), such as:

POST /{version}/me/drive/items/01CYZLFJGUJ7JHBSZDFZFL25KSZGQTVAUN/workbook/createSession

它总是返回 MethodNotAllowed:

It always returns MethodNotAllowed:

{"error": {"code": "MethodNotAllowed","message": "Method not allowed.","innerError": { "request-id": "9c1d81ec-4300-4e8b-b453-82cd6caca00e", "date": "2016-10-19T01:25:20"} } }

我尝试了 {version} v1.0 和 beta.

I tried {version} v1.0 and beta.

Graph Excel REST API 是否支持 OneDrive Personal?如果没有，什么时候可以?我找不到任何关于此的文档.我意识到 Graph 最近才开始通过 Azure AD 2.0 Endpoint 支持 OneDrive Personal，所以可能只是延迟了对 Excel 的支持?

Does the Graph Excel REST API support OneDrive Personal? If not, when might it? I can't find any documentation on this. I realize Graph just recently started supporting OneDrive Personal via Azure AD 2.0 Endpoint, so perhaps there's just a delay in supporting Excel?

推荐答案

OneDrive 个人版中的工作簿上访问 Excel REST API 的功能目前不可用.我们正在努力在不久的将来实现这一点.

The functionality to access Excel REST API on workbooks in OneDrive personal is not available at the moment. We are working on enabling this in the near future.