How to read dynamic excel sheets in excel read range and read cell activities

Help Activities
, ,
1

How to read dynamic excel sheets (ex: data 2024,data 2025).

I will get any one of the sheet(data 2024 or data 2025) in excel

How to provide excel sheet name in excel read range and read cell activities(classic)

2

Hi @balanirmalkumar.s

Is this what you are looking for

A workflow is designed to assign a dynamic sheet name "data 2024" and read its range and specific cell within an Excel file named "Inputfile.xlsx". (Captioned by AI)
A workflow is designed to assign a dynamic sheet name "data 2024" and read its range and specific cell within an Excel file named "Inputfile.xlsx". (Captioned by AI)650×592 15.9 KB

Hope this helps!

1 Like
3

Sheet will very for different excel file

4

@balanirmalkumar.s
How are you getting the sheet names?

If you want to read the sheets based on the index you can use the workflow below, This will read the sheet irrespective of its name

An Excel Application Scope automation sequence reads a workbook sheet, the range of cells, and a specific cell value in "Inputfile.xlsx". (Captioned by AI)
An Excel Application Scope automation sequence reads a workbook sheet, the range of cells, and a specific cell value in "Inputfile.xlsx". (Captioned by AI)685×586 15.5 KB

Hope this helps

5

Hey @balanirmalkumar.s if you want to read excel file dynamically you can use get workbook sheets so it will give you a collection of all the sheets present in the Excel file then you can use one if condition like given in the below screenshot.

The image shows a UiPath workflow designed to read and process data from specific sheets within an Excel file named "data.xlsx". (Captioned by AI)
The image shows a UiPath workflow designed to read and process data from specific sheets within an Excel file named "data.xlsx". (Captioned by AI)567×489 18.5 KB

cheers

6

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