Write to Excel worksheet Action(Power Automate Desktop)
An action that sets a value to a specified cell or range of cells.
- 1. How to use.
- 2. Links
- 2.1. Excel Actions.
- 2.2. Examples of Use
- 2.2.1. How to convert URL parameters (GET parameters) into Data table.
- 2.2.2. How to rank a list of numbers.
- 2.2.3. How to get the deviation.
- 2.2.4. Transcribing from one Excel book to another.
- 2.2.5. How to get the last business day of the specified month.
- 2.2.6. How to get the number of business days for a specify month.
- 2.2.7. How to get the number of business days within a specified period.
- 2.2.8. How to get the least common multiple and greatest common divisor.
- 2.2.9. How to convert between Roman numerals and Arabic numerals.
- 2.2.10. How to get the median.
- 2.2.11. How to get the standard deviation.
- 2.2.12. How to get the mode.
- 2.2.13. How to value paste value in Excel.
- 2.2.14. How to convert CSV files to Excel files
- 2.2.15. Create a table of contents for sheet names in an Excel book.
How to use.
First, place Launch Excel Action or Attach into running Excel and specify the Excel file to which you want to write the data.
Then, from Excel, drag Write to Excel worksheet to the workspace.
Set parameters.
The edited contents will not be reflected in the file as is.
If you wish to keep the edited content, you must save it using Save Excel Action or Close Excel Action at the end.
Parameters
Excel instance
Specify the Excel file to write data to.
Specify the Variables produced for the Launch Excel Action or the Attach to running Excel Action.
Value to write
Specifies the value to be written.
Fixed values, variables, formulas, List, and Data table can be specified.
In the case of a list or Data table, it is written in the range from the starting cell.
For Data table, column names are not written by themselves.
If column names are required, the ColumnHeadersRow is also written.
Write mode
Specify the cell to be written.
On specified cell
Specify additional columns and rows.
Specifying 1 for both column and row will result in cell A1.
Columns and rows are specified for the active sheet.
In the case of a file with multiple sheets, it is not clear which sheet is active.
it is unknown which sheet is active.
Therefore, it is recommended to specify the sheet in the Set active Excel worksheet Action.
If you want to write data in the last row or column of a table, you can also use Get first free column/row from Excel worksheet Action.
On currently active cell
Writes in the selected cell's value.
Variables produced
Not present in this action.
On error
Error handling is performed as needed.
Failed to retrieve first free column/row
This is an error when writing fails due to incorrect cell specification, etc.
---