Get table range from Excel worksheet Action(Power Automate Desktop)

Japanese version.

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.

Table of Contents.

Update History.

Links

Excel Actions.