Get table range from Excel worksheet Action(Power Automate Desktop)
This is an action that gets the position of a table or pivot table.
How to use
First, specify the target Excel file in the Launch Excel Action or the Attach to Running Excel Action, then drag the "Get table range from Excel worksheet" Action from "Excel.Advanced" onto the workspace.
Set parameters.
Parameters
Excel instance
Specify the target Excel file.
Specify the Variables produced for the Launch Excel Action or the Attach to running Excel Action.
Table Name
Specify the name of the table from which to obtain the position.
If the specified table does not exist, an error will occur.
Because there is no worksheet specification, the active
worksheet will be the target.
If there are multiple worksheets, it is unclear which sheet is active.
Therefore, we recommend specifying the sheet in “Set active Excel worksheet”.
Is pivot
Set to ON if the target is a pivot table.
If ON, only pivot table will be searched.
If OFF, only table will be searched.
Variables produced
This is a variable that stores the position of the table. It is a sequential number starting from 1.
If the table is A1 to C4, the following results will be obtained.
For those who want to learn Power Automate Desktop effectively
The information on this site is now available in an easy-to-read e-book format.
Or Kindle Unlimited (unlimited reading).
You willl discover how to about basic operations.
By the end of this book, you will be equipped with the knowledge you need to use Power Automate Desktop to streamline your workflow.