Excel | Composio Docs

Overview

SLUG

EXCEL

Description

Microsoft Excel is a powerful spreadsheet application for data analysis, calculations, and visualization, enabling users to organize and process data with formulas, charts, and pivot tables

Authentication Details

OAuth2

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

bearer_token

string

Tools

Add Table

SLUG: EXCEL_ADD_TABLE

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

objectRequired

error

string

successful

booleanRequired

Create Excel Session

SLUG: EXCEL_GET_SESSION

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

Action Parameters

item_id

stringRequired

persist_changes

booleanDefaults to True

Action Response

data

objectRequired

error

string

successful

booleanRequired

List Table Columns

SLUG: EXCEL_LIST_TABLE_COLUMNS

List columns in a table using microsoft graph api.

Action Parameters

item_id

stringRequired

session_id

string

table_id

stringRequired

Action Response

data

objectRequired

error

string

successful

booleanRequired

Add Chart

SLUG: EXCEL_ADD_CHART

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

objectRequired

error

string

successful

booleanRequired

Add Table Column

SLUG: EXCEL_ADD_TABLE_COLUMN

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

objectRequired

error

string

successful

booleanRequired

Add Table Row

SLUG: EXCEL_ADD_TABLE_ROW

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

objectRequired

error

string

successful

booleanRequired

Add Worksheet

SLUG: EXCEL_ADD_WORKSHEET

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

objectRequired

error

string

successful

booleanRequired

Apply Table Filter

SLUG: EXCEL_APPLY_TABLE_FILTER

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

objectRequired

error

string

successful

booleanRequired

Apply Table Sort

SLUG: EXCEL_APPLY_TABLE_SORT

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

objectRequired

error

string

successful

booleanRequired

Clear Table Filter

SLUG: EXCEL_CLEAR_TABLE_FILTER

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

objectRequired

error

string

successful

booleanRequired

Convert Table To Range

SLUG: EXCEL_CONVERT_TABLE_TO_RANGE

Convert a table to a range using microsoft graph api.

Action Parameters

item_id

stringRequired

session_id

string

table_id

stringRequired

Action Response

data

objectRequired

error

string

successful

booleanRequired

Delete Table Column

SLUG: EXCEL_DELETE_TABLE_COLUMN

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

objectRequired

error

string

successful

booleanRequired

Delete Table Row

SLUG: EXCEL_DELETE_TABLE_ROW

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

objectRequired

error

string

successful

booleanRequired

Get Range

SLUG: EXCEL_GET_RANGE

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

objectRequired

error

string

successful

booleanRequired

Get Worksheet

SLUG: EXCEL_GET_WORKSHEET

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

objectRequired

error

string

successful

booleanRequired

List Charts

SLUG: EXCEL_LIST_CHARTS

List charts in a worksheet using microsoft graph api.

Action Parameters

item_id

stringRequired

session_id

string

worksheet

stringRequired

Action Response

data

objectRequired

error

string

successful

booleanRequired

List Named Items

SLUG: EXCEL_LIST_NAMED_ITEMS

List named items in a workbook using microsoft graph api.

Action Parameters

item_id

stringRequired

session_id

string

Action Response

data

objectRequired

error

string

successful

booleanRequired

List Tables

SLUG: EXCEL_LIST_TABLES

List tables in a worksheet using microsoft graph api.

Action Parameters

item_id

stringRequired

session_id

string

worksheet

stringRequired

Action Response

data

objectRequired

error

string

successful

booleanRequired

List Table Rows

SLUG: EXCEL_LIST_TABLE_ROWS

List rows in a table using microsoft graph api.

Action Parameters

item_id

stringRequired

session_id

string

table_id

stringRequired

Action Response

data

objectRequired

error

string

successful

booleanRequired

List Worksheets

SLUG: EXCEL_LIST_WORKSHEETS

List worksheets in an excel workbook using microsoft graph api.

Action Parameters

item_id

stringRequired

session_id

string

Action Response

data

objectRequired

error

string

successful

booleanRequired