Read Range with single, unknown named sheet

Hey team,

Wondering if someone knows a way, without opening excel, to Read Range of an excel file that has only 1 sheet…without knowing the name of that sheet to start with??

Essentially i want my staff to drop an excel file in a folder and just run the Workflow…in the Workflow it Reads Range, but the sheet name will not matter as there will only ever be 1 sheet in those excel files.

Cheers
MikeB

Hello,

You can find first sheet name with GetWorkbookSheet

3 Likes

Hi,

Please try the Getworkbooksheet activity:;

Properties

Common

  • DisplayName - The display name of the activity.

Input

  • Index - The index of the sheet that you want to retrieve. This field supports only integers and Int32 variables.

Misc

  • Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

Output

  • Sheet - The name of the retrieved sheet. This field supports only strings and String variables.

You can download the example from (https://docs.uipath.com/activities/docs/interpret-excel-results).

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.