Excel

Learn how to use Excel with Composio

Overview

Enum

EXCEL

Description

Connect to Excel to create and manage spreadsheets.

Authentication Details

client_id
stringRequired
client_secret
stringRequired
oauth_redirect_uri
stringDefaults to https://backend.composio.dev/api/v1/auth-apps/add
scopes
stringDefaults to Files.ReadWrite,Sites.ReadWrite.All,offline_access,User.Read

Actions

Add a chart to a worksheet using microsoft graph api.

Action Parameters

item_id
stringRequired
seriesby
stringRequired
session_id
string
sourcedata
stringRequired
type
stringRequired
worksheet
stringRequired

Action Response

data
object
error
successful
boolean

Create a table in a workbook using microsoft graph api.

Action Parameters

hasHeaders
booleanRequired
item_id
stringRequired
name
stringRequired
session_id
string
showTotals
booleanRequired
style
stringRequired
table_id
stringRequired

Action Response

data
object
error
successful
boolean

Add a column to a table using microsoft graph api.

Action Parameters

index
integerRequired
item_id
stringRequired
session_id
string
table_id
stringRequired
values
arrayRequired

Action Response

data
object
error
successful
boolean

Add a row to a table using microsoft graph api.

Action Parameters

index
integer
item_id
stringRequired
session_id
string
table_id
stringRequired
values
arrayRequired

Action Response

data
object
error
successful
boolean

Add a new worksheet to an excel workbook using microsoft graph api.

Action Parameters

item_id
stringRequired
name
stringRequired
session_id
string

Action Response

data
object
error
successful
boolean

Apply a filter to a table column using microsoft graph api.

Action Parameters

column_id
stringRequired
criteria
objectRequired
item_id
stringRequired
session_id
string
table_id
stringRequired
worksheet
stringRequired

Action Response

data
object
error
successful
boolean

Apply a sort to a table using microsoft graph api.

Action Parameters

fields
arrayRequired
item_id
stringRequired
session_id
string
table_id
stringRequired
worksheet
stringRequired

Action Response

data
object
error
successful
boolean

Clear a filter from a table column using microsoft graph api.

Action Parameters

column_id
stringRequired
item_id
stringRequired
session_id
string
table_id
stringRequired
worksheet
stringRequired

Action Response

data
object
error
successful
boolean

Convert a table to a range using microsoft graph api.

Action Parameters

item_id
stringRequired
session_id
string
table_id
stringRequired

Action Response

data
object
error
successful
boolean

Delete a column from a table using microsoft graph api.

Action Parameters

column_id
stringRequired
item_id
stringRequired
session_id
string
table_id
stringRequired

Action Response

data
object
error
successful
boolean

Delete a row from a table using microsoft graph api.

Action Parameters

item_id
stringRequired
row_index
integerRequired
session_id
string
table_id
stringRequired

Action Response

data
object
error
successful
boolean

Get a range from a worksheet using microsoft graph api.

Action Parameters

address
stringRequired
item_id
stringRequired
session_id
string
worksheet_id
stringRequired

Action Response

data
object
error
successful
boolean

Create a session for an excel workbook using microsoft graph api.

Action Parameters

item_id
stringRequired
persist_changes
booleanDefaults to True

Action Response

data
object
error
successful
boolean

Get a worksheet by name or id from an excel workbook using microsoft graph api.

Action Parameters

item_id
stringRequired
session_id
string
worksheet
stringRequired

Action Response

data
object
error
successful
boolean

List charts in a worksheet using microsoft graph api.

Action Parameters

item_id
stringRequired
session_id
string
worksheet
stringRequired

Action Response

data
object
error
successful
boolean

List named items in a workbook using microsoft graph api.

Action Parameters

item_id
stringRequired
session_id
string

Action Response

data
object
error
successful
boolean

List tables in a worksheet using microsoft graph api.

Action Parameters

item_id
stringRequired
session_id
string
worksheet
stringRequired

Action Response

data
object
error
successful
boolean

List columns in a table using microsoft graph api.

Action Parameters

item_id
stringRequired
session_id
string
table_id
stringRequired

Action Response

data
object
error
successful
boolean

List rows in a table using microsoft graph api.

Action Parameters

item_id
stringRequired
session_id
string
table_id
stringRequired

Action Response

data
object
error
successful
boolean

List worksheets in an excel workbook using microsoft graph api.

Action Parameters

item_id
stringRequired
session_id
string

Action Response

data
object
error
successful
boolean

Sort a range in a worksheet using microsoft graph api.

Action Parameters

fields
arrayRequired
item_id
stringRequired
range_type
stringRequired
session_id
string
worksheet
stringRequired

Action Response

data
object
error
successful
boolean

Update a chart in a worksheet using microsoft graph api.

Action Parameters

chart_id
stringRequired
height
number
item_id
stringRequired
left
number
name
string
session_id
string
top
number
width
number
worksheet
stringRequired

Action Response

data
object
error
successful
boolean

Update a range in a worksheet using microsoft graph api.

Action Parameters

address
stringRequired
item_id
stringRequired
session_id
string
values
arrayRequired
worksheet_id
stringRequired

Action Response

data
object
error
successful
boolean

Update a table in a workbook using microsoft graph api.

Action Parameters

item_id
stringRequired
name
string
session_id
string
showHeaders
boolean
showTotals
boolean
style
string
table_id
stringRequired

Action Response

data
object
error
successful
boolean

Update worksheet properties (name, position) in an excel workbook using microsoft graph api.

Action Parameters

item_id
stringRequired
name
string
position
integer
session_id
string
worksheet
stringRequired

Action Response

data
object
error
successful
boolean