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 を使うテンプレート


Import Excel Contacts to Salesforce
Find or create Salesforce accounts and upsert workbook contacts by email.


Email Hacker News Headlines as a Spreadsheet
Email the current Hacker News front-page titles and links in a spreadsheet attachment.


Search OneDrive for Excel Workbooks
Search the current user’s OneDrive for the text .xlsx and return the first page of results.
すべての操作
Create Workbook
Create a new .xlsx workbook file and optionally populate worksheets and data.
excel.create_workbookSearch Files
Search workbook files in the current OneDrive drive and return matching drive items.
excel.search_filesList Drive Item Children
List direct child drive items for a folder or the drive root.
excel.list_drive_item_childrenCreate Session
Create an Excel workbook session for subsequent workbook operations.
excel.create_sessionGet Workbook
Read workbook metadata and optionally expand related workbook resources.
excel.get_workbookList Worksheets
List worksheets in a workbook.
excel.list_worksheetsGet Worksheet
Read a single worksheet by worksheet name or worksheet ID.
excel.get_worksheetAdd Worksheet
Add a new worksheet to a workbook.
excel.add_worksheetUpdate Worksheet
Update worksheet metadata such as the name, position, or visibility.
excel.update_worksheetDelete Worksheet
Delete one worksheet from a workbook.
excel.delete_worksheetGet Range
Read one worksheet range by A1-style address.
excel.get_rangeGet Worksheet Used Range
Read the used range for one worksheet.
excel.get_worksheet_used_rangeUpdate Range
Update one worksheet range with values, formulas, formats, or visibility flags.
excel.update_rangeClear Range
Clear one worksheet range.
excel.clear_rangeInsert Range
Insert one worksheet range and shift existing cells to make space.
excel.insert_rangeMerge Cells
Merge cells inside one worksheet range.
excel.merge_cellsSort Range
Apply a Microsoft Graph sort definition to one worksheet range.
excel.sort_rangeList Tables
List workbook tables, optionally restricted to one worksheet.
excel.list_tablesAdd Table
Create a new workbook table from an address range.
excel.add_tableUpdate Table
Update table metadata such as the name, style, or header flags.
excel.update_tableConvert Table To Range
Convert a workbook table back into a plain worksheet range.
excel.convert_table_to_rangeList Table Rows
List rows for one workbook table.
excel.list_table_rowsAdd Table Row
Add one or more rows to a workbook table.
excel.add_table_rowDelete Table Row
Delete one row from a workbook table by row index.
excel.delete_table_rowList Table Columns
List columns for one workbook table.
excel.list_table_columnsGet Table Column
Read one workbook table column by column name or column ID.
excel.get_table_columnAdd Table Column
Add one column to a workbook table.
excel.add_table_columnDelete Table Column
Delete one column from a workbook table.
excel.delete_table_columnApply Table Filter
Apply a Microsoft Graph filter criteria object to one table column.
excel.apply_table_filterClear Table Filter
Clear the current Microsoft Graph filter on one table column.
excel.clear_table_filterApply Table Sort
Apply a Microsoft Graph sort definition to one workbook table.
excel.apply_table_sort検索条件に一致する操作はありません。
Excel を Open Flow に接続
毎月 20,000 回のアプリ呼び出しが無料(有料サービスは別途課金)