Get all Excel worksheets Action(Power Automate Desktop)
This action retrieves the names of sheets in a workbook in list.
How to use
First, specify the Excel file whose data you want to read in the Launch Excel Action or the Attach to Running Excel Action, then drag the Get all Excel worksheets Action from Excel onto the workspace.
Specify the Variables produced for the Launch Excel Action or the Attach to running Excel Action.
The names of all sheets present in the Excel instance are stored in the list.
Error handling is performed as needed.
Failed to retrieve all worksheet names
An error occurs if the sheet information fails to be retrieved, for example, if the Excel worksheet is inaccessible.