How to pass excel sheet name in Excel read range

Help Studio
, ,
1

How to pass excel sheet name in Excel read range activity
My excel can have sheet0 or sheet1
i tried using assign sheetName=“sheet0” or “sheet1”
but its throwing error

2

@shilpashree.mohanty

check this thread
what is the error you got?

3

Hi @shilpashree.mohanty

Try this

The image shows a UiPath sequence workflow where an Excel file is being processed by iterating over each sheet to read the visible rows into a data table. (Captioned by AI)
The image shows a UiPath sequence workflow where an Excel file is being processed by iterating over each sheet to read the visible rows into a data table. (Captioned by AI)818×1233 48.2 KB

Regards,

4

we cant use workbook or modern activity
any way in read range itself?
image

5

@shilpashree.mohanty

Can try with Try/Catch activity

This image depicts a UiPath workflow sequence using a Try Catch activity to read data from an Excel file and display the row count in a message box. (Captioned by AI)
This image depicts a UiPath workflow sequence using a Try Catch activity to read data from an Excel file and display the row count in a message box. (Captioned by AI)818×584 26 KB

The image shows a UiPath workflow using a Try Catch block to read a range from an Excel file and then displaying the row count in a message box. (Captioned by AI)
The image shows a UiPath workflow using a Try Catch block to read a range from an Excel file and then displaying the row count in a message box. (Captioned by AI)610×627 15.3 KB

Regards,

6

Any linq query to get or assign activity?

7

What can you use then?

8

@shilpashree.mohanty

If there is only one aheet then you need not pass the name as well if you use use excel file activity

Cna you confirm

If not use classic get worksheets and check the sheetname that exists and use it

Cheers