Where to look along the vertical axis, based on the position of the currently active cell Where to look along the horizontal axis, based on currently activated cell's position Specify whether to select an explicitly specified range of cells or a range of cells relatively to the currently active cell Selects a range of cells in the active worksheet of an Excel instance Input Parameters Argument Indicates a problem activating an Excel cell The distance in cells between the currently active cell and the desired cell. Select where to look for the cell to activate based on the position of the currently active cell The numeric value or letter of the cell column Select whether to specify the cell to activate absolutely, or relatively, by using an offset distance being the number of cells between the currently activated reference cell and the actual cell activate This variable must have been previously specified in a Launch Excel actionĪbsolutely specified cell, Relatively specified cell Indicates a problem renaming the specified worksheetĪctivate a cell in the active worksheet of an Excel instance, by providing column, row and offset Input Parameters Argument The numbering starts from 1, meaning that the index of the fist worksheet is 1, of the second is 2 etc. Specify whether to find the worksheet by name or index Renames a specific worksheet of an Excel instance Input Parameters Argument Indicates a problem deleting the specified worksheet Indicates that a worksheet with the specified name could not be found The numbering starts from 1, meaning that the index of the fist worksheet is 1, the second one is 2 etc. The Index number of the worksheet to delete. Whether to find the worksheet by name or index Indicates a problem retrieving the names of the Excel worksheetĭeletes a specific worksheet from an Excel instance Input Parameters Argument This variable must have been previously specified in a Launch Excel action Retrieves all worksheet names of an Excel document Input Parameters Argument Indicates a problem retrieving the active worksheet Retrieves an Excel document's active worksheet Input Parameters Argument Indicates a problem running the specified macro This action doesn't produce any variables.The text should consist of the name of the macro, followed by any arguments (optional), all separated by semicolons Runs a specified macro on the document of an Excel instance Input Parameters Argument The result is that the A51 to E55 cell range is filled with the contents of the datatable.Īdvanced Excel automation actions Run Excel Macro In the following example, the action writes the above mentioned datatable variable to cell A51.Įach cell in the workbook is populated with its corresponding cell in the datatable. This action can write any static data or variable to a specified cell, or multiple cells in an Excel worksheet. Write data from the flow to Excel by using the Write to Excel Worksheet action. When the flow runs, the action stores the data in a datatable type variable: The action has to have the following configuration: In the following example, to read the cells A1 through E5 as seen in the selection below: Retrieve the value of a single cell, or a table of data.
To read and extract data from an Excel document, use the Read from Excel Worksheet action.
#Remove dymo from excel free
Get first free column/row from Excel worksheetĪfter setting an Excel instance, either with the Launch Excel or the Attach to running Excel action, you may read from or write to an Excel file.
Get first free row on column from Excel worksheet Get selected cell range from Excel worksheetįind and replace cells in Excel worksheet