# Microsoft Excel

Microsoft Excel (opens new window) is a spreadsheet developed by Microsoft. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.

🔑 Credentials

You can find authentication information for this node here.

# Basic Operations

Table
  • Add rows to the end of the table
  • Retrieve a list of table columns
  • Retrieve a list of table rows
  • Look for a specific column value and return the matching row
Workbook
  • Add a new worksheet to a workbook
  • Get data of all workbooks
Worksheet
  • Get all worksheets
  • Get worksheet content

# Example Usage

This workflow allows you to get information about all workbooks from Microsoft Excel. You can also find the workflow (opens new window) on the website. This example usage workflow would use the following two nodes.

The final workflow should look like the following image.

A workflow with the Microsoft Excel node

# 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.