RangeFormat: autofitColumnsRangeFormat: autofitColumns

命名空间:microsoft.graphNamespace: microsoft.graph


/betaMicrosoft Graph 中的版本下的 api 可能会发生更改。APIs under the /beta version in Microsoft Graph are subject to change. 不支持在生产应用程序中使用这些 API。Use of these APIs in production applications is not supported. 若要确定 API 在 v1.0 中是否可用,请使用 版本 选择器。To determine whether an API is available in v1.0, use the Version selector.

根据列中的当前数据更改当前范围的列宽,以达到最佳宽度。Changes the width of the columns of the current range to achieve the best fit, based on the current data in the columns.


要调用此 API,需要以下权限之一。要了解详细信息,包括如何选择权限的信息,请参阅权限One of the following permissions is required to call this API. To learn more, including how to choose permissions, see Permissions.

权限类型Permission type 权限(从最低特权到最高特权)Permissions (from least to most privileged)
委派(工作或学校帐户)Delegated (work or school account) Files.ReadWriteFiles.ReadWrite
委派(个人 Microsoft 帐户)Delegated (personal Microsoft account) Files.ReadWriteFiles.ReadWrite
应用程序Application 不支持。Not supported.

HTTP 请求HTTP request

POST /workbook/names/{name}/range/format/autofitColumns
POST /workbook/worksheets/{id|name}/range(address='<address>')/format/autofitColumns
POST /workbook/tables/{id|name}/columns/{id|name}/range/format/autofitColumns

请求标头Request headers

名称Name 说明Description
AuthorizationAuthorization Bearer {token}。必需。Bearer {token}. Required.
Workbook-Session-IdWorkbook-Session-Id 确定是否保留更改的工作簿会话 ID。可选。Workbook session Id that determines if changes are persisted or not. Optional.

请求正文Request body


如果成功,此方法返回 200 OK 响应代码。它不在响应正文中返回任何内容。If successful, this method returns 200 OK response code. It does not return anything in the response body.


下面是一个如何调用此 API 的示例。Here is an example of how to call this API.


下面是一个请求示例。Here is an example of the request.

POST https://graph.microsoft.com/beta/me/drive/items/{id}/workbook/names/{name}/range/format/autofitColumns

下面是一个响应示例。Here is an example of the response.

HTTP/1.1 200 OK