Skip to content

Microsoft Excel#

Use the Microsoft Excel node to automate work in Microsoft Excel, and integrate Microsoft Excel with other applications. Ensemble has built-in support for a wide range of Microsoft Excel features, including adding and retrieving lists of table data, and workbooks, as well as getting worksheets.

On this page, you'll find a list of operations the Microsoft Excel node supports and links to more resources.

Credentials

Refer to Microsoft Excel credentials for guidance on setting up authentication.

Basic Operations#

  • Table
    • Adds rows to the end of the table
    • Retrieve a list of tablecolumns
    • Retrieve a list of tablerows
    • Looks for a specific column value and then returns the matching row
  • Workbook
    • Adds a new worksheet to the workbook.
    • Get data of all workbooks
  • Worksheet
    • Get all worksheets
    • Get worksheet content

Example Usage#

This Pathway allows you to get information about all workbooks from Microsoft Excel. This example usage Pathway would use the following two nodes. - Start - Microsoft Excel

1. Start node#

The start node exists by default when you create a new workflow.

2. Microsoft Excel node#

  1. First of all, you'll have to enter credentials for the Microsoft Excel node. You can find out how to do that here.
  2. Select the 'Get All' option from the Operation dropdown list.
  3. Click on Execute Node to run the workflow.