Microsoft Excel

A BDK Book containing procedures for working with Microsoft Excel.

Overview

The Excel book enables users to interact with and manage Excel files and workbooks via the Microsoft Graph API.

Prerequisites

Learning the Microsoft Excel Book (BDK)

Before using the Book’s procedures in an automation, you must learn the Book by adding it to your agent. Follow the steps below to get started.

1. In the left navigation bar, click on Books.

2. Click on + New Book.

3. Search for the Book's name. Click on the version tagged with bdk.

Note: If the Book requires connectivity, you will be prompted to provide configuration details.

1. Click Add to finish adding your Book.

After learning a Book, publish your agent and create a new Playground. Previously created Playgrounds will not be able to recognize the new Book.

Connectivity

This Book supports the connectivity methods described in this section.

Connect using Client ID, Client Secret and Tenant ID

Establishes a connection to the Microsoft Graph API using the provided client credentials.

Label	Description	Type
Client ID	The client ID of the application registered in Azure AD.	text
Client Secret	The client secret of the application registered in Azure AD.	text
Tenant ID	The tenant ID of the Azure AD directory.	text