When you configure an export, import, or other type of flow step using the prebuilt Microsoft Excel Online connector, you can select any of the API operations listed below*, organized by API type.
Note
If your API endpoint isn’t listed here, switch the flow step to HTTP mode and configure the endpoint provided in the Microsoft Excel Online API documentation. *You can also create a composite endpoint for this application in HTTP mode.
Resource |
API endpoint |
Export |
Import |
---|---|---|---|
Workbook |
List worksheets |
X |
|
List names |
X |
||
List tables |
X |
||
Workbook table row operation result |
X |
||
Close session |
X |
||
Refresh session |
X |
||
Create session |
X |
||
Workbook application |
Get workbook application |
X |
|
Workbook application: Calculate |
X |
||
Create workbook comment reply |
X |
||
Workbook comment |
List workbook comments |
X |
|
List workbook comment replies |
X |
||
Get workbook comment |
X |
||
Get workbook comment reply |
X |
||
Workbook table row |
List table row collection |
X |
|
List table row collection by worksheets |
X |
||
Get table row by table |
X |
||
Get table row by worksheet |
X |
||
Table row: Range by table |
X |
||
Table row: Range by worksheet |
X |
||
Table row collection: Item at by table |
X |
||
Table row collection: Item at by worksheet |
X |
||
Create table row |
X |
||
Update table row |
X |
||
Delete table row |
X |
||
Table row collection: Add |
X |
||
Table row collection: Add by worksheet |
X |
||
Worksheet |
Get worksheet |
X |
|
Worksheet: Used range |
X |
||
Worksheet: Get cell |
X |
||
Worksheet: Get range |
X |
||
List tables |
X |
||
List charts |
X |
||
Worksheet collection: Add |
X |
||
Update worksheet |
X |
||
Delete worksheet |
X |
||
Create table |
X |
||
Create chart |
X |
||
Range |
Get range |
X |
|
Get range column |
X |
||
Get range format by address |
X |
||
Get range format |
X |
||
Get range format by columns |
X |
||
Insert range |
X |
||
Insert range by address |
X |
||
Insert range by column |
X |
||
Update range |
X |
||
Update range by address |
X |
||
Update range by column |
X |
||
Update range format |
X |
||
Update range format by address |
X |
||
Update range format by column |
X |
||
Merge range |
X |
||
Merge range by address |
X |
||
Merge range by column |
X |
||
Unmerge range |
X |
||
Unmerge range by address |
X |
||
Unmerge range by column |
X |
||
Clear range |
X |
||
Clear range by address |
X |
||
Clear range by column |
X |
||
Delete range |
X |
||
Table |
Get table |
X |
|
Get table by worksheet |
X |
||
List rows |
X |
||
List columns |
X |
||
Workbook table: Range |
X |
||
Add table |
X |
||
Add table by worksheet |
X |
||
Update table |
X |
||
Update table by worksheet |
X |
||
Delete table |
X |
||
Create row |
X |
||
Create row by worksheet |
X |
||
Delete row |
X |
||
Delete row by worksheet |
X |
||
Delete column |
X |
||
Delete column by worksheet |
X |
||
Create column |
X |
||
Create column by worksheet |
X |
||
Chart |
List chart collection |
X |
|
Get Chart |
X |
||
Chart: Image |
X |
||
Chart collection: Add |
X |
||
Update chart |
X |
||
Delete chart |
X |
||
Chart: Set data |
X |
||
Chart: Set position |
X |
||
Named item |
List named item collection |
X |
|
Get named item |
X |
||
Named item: Range |
X |
||
Add named item |
X |
||
Update named item by worksheet |
X |
Comments
Please sign in to leave a comment.