Microsoft Excel

Her Microsoft Excel eylemi için minimum standart temsil edilen (delegated) kapsam eşlemesini inceleyin. Eşleme şunları kapsar: çalışma kitapları, çalışma sayfaları, aralıklar ve tablolar.

Files.ReadWrite.All is the platform standard for all Excel actions, including read actions. Microsoft Graph lists Files.ReadWrite as the least privileged permission for resolving a workbook from a sharing URL (GET /shares/{u!}/driveItem). Files.Read and Files.Read.All are not enough for that API. While personal /me/drive workbooks can technically execute with Files.Read or Files.ReadWrite, Excel workbooks frequently reside in SharePoint document libraries, Microsoft 365 Groups, or are accessed through direct file URLs. Removing .All restricts access exclusively to personal OneDrive files and breaks access to workbooks stored in SharePoint document libraries or shared via links. Microsoft Graph does not support Sites.Selected or Files.SelectedOperations.Selected for Excel /workbook/ session operations.

Eylem başına minimum kapsamlar

Her Microsoft Excel bağlantısı ayrıca openid, offline_access ve User.Read ister.

Eylem Açıklama Minimum kapsamlar

Add sheet to workbook a worksheet to an existing Excel workbook ekler. Files.ReadWrite.All

Add table row a new row to the end of a table ekler. Files.ReadWrite.All

Clear range Clears cell contents, formatting, or both from a range without deleting the cells. Files.ReadWrite.All

Create chart a chart from data in a range oluşturur. Files.ReadWrite.All

Create table a new table from a cell range. Tables enable filtering, sorting, and structured references oluşturur. Files.ReadWrite.All

Delete column a column from bir çalışma sayfası, shifting remaining columns left siler. Files.ReadWrite.All

Delete row a row from bir çalışma sayfası, shifting remaining rows up siler. Files.ReadWrite.All

Delete table row a specific row from a table given its row index siler. Files.ReadWrite.All

Format cells formatting to cells including font styles, background colors, and borders uygular. Files.ReadWrite.All

Get all table columns all columns from a table getirir. Files.ReadWrite.All

Get item by name for Excel dosyalar by name or resolves a direct URL. Returns file ID, driveId, name, URL, and metadata for use with other Excel actions arar. Files.ReadWrite.All

Get range data from a specified cell range in bir çalışma sayfası. Use this to read data that is not in a table getirir. Files.ReadWrite.All

Get sheet by item id all çalışma sayfaları of an Excel workbook getirir. Files.ReadWrite.All

Get single table row a specific row from a table given its row index getirir. Files.ReadWrite.All

Get table rows rows from a table with pagination support, including the table name. Use this to read data from Excel tables getirir. Files.ReadWrite.All

Get tables all tables from bir çalışma sayfası, specified by item id and sheet id getirir. Files.ReadWrite.All

Get workbook summary a summary of an Excel workbook including all sheets, their data ranges, tables, and charts getirir. Files.ReadWrite.All

Insert column Inserts a new empty column to the left or right of a specified column, shifting existing columns. Files.ReadWrite.All

Insert formulas Inserts Excel formulas into cells at a specified range. Use this to add calculations like =SUM(), =AVERAGE(), =IF(), etc. Files.ReadWrite.All

Insert row Inserts a new empty row above or below a specified row, shifting existing rows down. Files.ReadWrite.All

Merge cells Merges cells in a range into a single cell. Files.ReadWrite.All

Resolve drive Resolves drive metadata by ID or searches for drives by name. Returns standardized items for ID field resolution. Files.ReadWrite.AllSites.Read.All

Resolve item Resolves Excel file metadata by ID or searches for files by name. Returns standardized items for ID field resolution. Files.ReadWrite.All

Resolve table Resolves table metadata by ID or searches for tables by name. Requires driveId and itemId. Files.ReadWrite.All

Resolve worksheet Resolves worksheet metadata by ID or searches for worksheets by name. Requires driveId and itemId. Files.ReadWrite.All

Set alignment text alignment for cells (horizontal and vertical) ayarlar. Files.ReadWrite.All

Set number format the number format for cells (currency, percentage, date, etc.) ayarlar. Files.ReadWrite.All

Sort range data in a range by one or more columns sıralar. Files.ReadWrite.All

Update cells cells in bir çalışma sayfası at a specified range günceller. Files.ReadWrite.All

Update table row values in a specific row or range within an Excel table günceller. Files.ReadWrite.All

Related pages

• Microsoft Integration Scopes
• Microsoft integrations: permissions and admin approval