Excel automation in WinAutomation

Beginner
Intermediate
App Maker
Developer
Functional Consultant
Microsoft Power Platform
Power Automate

WinAutomation provides an extensive variety of Microsoft Excel actions to help you read and manipulate Excel files.

Learning objectives

In this module, you will:

  • Open Excel files and attach a process to an already opened file.
  • Use the Excel group of actions to read data from and write data to an Excel file.
  • Create and edit worksheets.
  • Save and close Excel files.

Prerequisites

  • Basic familiarity with the WinAutomation Console and Process Designer
  • Basic familiarity with Microsoft Excel