將 Excel 連接至 Open Flow

Provide a workbook, worksheet, and range so the assistant can read data or make the changes you specify.

每月 20,000 次免費應用程式呼叫(付費服務另計)

應用程式介紹和工具詳情以英文提供。

可以做什麼

The connection uses Microsoft Graph to work with Excel workbooks, worksheets, ranges, and tables. It can create XLSX workbooks, read cells, and update data or formatting.

Read Workbooks and Ranges

Find workbooks, list worksheets, and read selected or used cell ranges.

Update Cells and Tables

Write values or formulas to ranges, create tables, and add rows.

使用 Excel 的範本

所有工具

31 個工具

Create Workbook

Create a new .xlsx workbook file and optionally populate worksheets and data.

excel.create_workbook

Search Files

Search workbook files in the current OneDrive drive and return matching drive items.

excel.search_files

List Drive Item Children

List direct child drive items for a folder or the drive root.

excel.list_drive_item_children

Create Session

Create an Excel workbook session for subsequent workbook operations.

excel.create_session

Get Workbook

Read workbook metadata and optionally expand related workbook resources.

excel.get_workbook

List Worksheets

List worksheets in a workbook.

excel.list_worksheets

Get Worksheet

Read a single worksheet by worksheet name or worksheet ID.

excel.get_worksheet

Add Worksheet

Add a new worksheet to a workbook.

excel.add_worksheet

Update Worksheet

Update worksheet metadata such as the name, position, or visibility.

excel.update_worksheet

Delete Worksheet

Delete one worksheet from a workbook.

excel.delete_worksheet

Get Range

Read one worksheet range by A1-style address.

excel.get_range

Get Worksheet Used Range

Read the used range for one worksheet.

excel.get_worksheet_used_range

Update Range

Update one worksheet range with values, formulas, formats, or visibility flags.

excel.update_range

Clear Range

Clear one worksheet range.

excel.clear_range

Insert Range

Insert one worksheet range and shift existing cells to make space.

excel.insert_range

Merge Cells

Merge cells inside one worksheet range.

excel.merge_cells

Sort Range

Apply a Microsoft Graph sort definition to one worksheet range.

excel.sort_range

List Tables

List workbook tables, optionally restricted to one worksheet.

excel.list_tables

Add Table

Create a new workbook table from an address range.

excel.add_table

Update Table

Update table metadata such as the name, style, or header flags.

excel.update_table

Convert Table To Range

Convert a workbook table back into a plain worksheet range.

excel.convert_table_to_range

List Table Rows

List rows for one workbook table.

excel.list_table_rows

Add Table Row

Add one or more rows to a workbook table.

excel.add_table_row

Delete Table Row

Delete one row from a workbook table by row index.

excel.delete_table_row

List Table Columns

List columns for one workbook table.

excel.list_table_columns

Get Table Column

Read one workbook table column by column name or column ID.

excel.get_table_column

Add Table Column

Add one column to a workbook table.

excel.add_table_column

Delete Table Column

Delete one column from a workbook table.

excel.delete_table_column

Apply Table Filter

Apply a Microsoft Graph filter criteria object to one table column.

excel.apply_table_filter

Clear Table Filter

Clear the current Microsoft Graph filter on one table column.

excel.clear_table_filter

Apply Table Sort

Apply a Microsoft Graph sort definition to one workbook table.

excel.apply_table_sort

將 Excel 連接至 Open Flow

連接 Excel

每月 20,000 次免費應用程式呼叫(付費服務另計)