Answered

How to specify a specific sheet in an Excel workbook for PAD actions

(0) Share

Report

Posted on by JM12345

When running actions in Excel such as "Read from Excel worksheet", is it possible to name a specific sheet to work with? If you have a workbook with several sheets, PAD seems to pull from whichever one the user last dealt with, which might not always be the correct sheet for the action.

Categories:

Power Automate Desktop

All responses (3)

Answers (1)

Sort by

Verified answer

UshaJyothiKasibhotla 225 Moderator on at

Like
a
(4)

Report
Copy link

Link copied!

Hi @JM12345

There is an activity called set active work sheet and give the input sheet name...then you can do the operations which you need to....

Hope this helps

Usha
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@JM12345
Please use “set active worksheet” action to activate your worksheet first.

-------------------------------------------------------------------------------------------------------------------------
If I've resolved your query, please consider accepting it as the solution and giving it a thumbs up to help others find answers faster.
JM12345 20 on at

Like
a
(1)

Report
Copy link

Link copied!

Found the command, I will try it, thanks!