Write to an Excel worksheet
You can also write data from the flow to Excel by using the Write to Excel worksheet action. This action can write any static data or variable to a specified cell, or multiple cells in an Excel worksheet. The action supports two writing modes:
Write on a specified cell.
Write on the currently active cell.
On named cells
Activate a specific cell
In this example, we want to activate a specific cell that we'll be writing to. To specify a particular cell to be active, use the Activate cell in Excel worksheet action.
Write to Excel Worksheet
To write data to Excel, use the Write to Excel Worksheet action. Within this action there are three options for the Write mode:
On currently active cell: The currently active cell is the cell that is active in the workbook at the time the action runs. If you used an Activate cell in Excel worksheet action, then the currently active cell would be the cell selected in the Activate cell in Excel worksheet action.
On specified cell: The specified cell allows you to manually input which cell should be written to.
On named cells
The Write to Excel worksheet action accepts previously defined Excel instance as an input and doesn't return any outputs.