Assign excel sheet

[omar_ismail]

I have an excel sheet its name changed every day when extracted so how can I create a variable for it

[Sudharsan_Ka]

HI @omar_ismail

What will be changing in the name can you tell any example?

Regards
Sudharsan

[Sudharsan_Ka]

@omar_ismail

extracted

Means you are downloading from any platform?

[omar_ismail]

yes i am downloading a CSV excel sheet and the sheet name contains today date so every day will be in a deffrient name so i need to get a varible to be able to use it in the read range activity

[fernando_zuluaga]

Hi @omar_ismail

first activity will retrieve a list of all sheets, based on that you can search for the one that you want

second activity you can get the sheet name based on the index

Regards

[omar_ismail]

can I know in which package these activities

[fernando_zuluaga]

Filter options → Show Classic

[Sudharsan_Ka]

These are in Excel.Activities @omar_ismail

If you dont find one Go to Activities Filters → Click on Classic

[omar_ismail]

I got the activities, what is the next step I didn’t get it before can you elaborate?

[raja.arslankhan (Raja Muhammad Arslan khan)]

@omar_ismail I am attching workflow give me time.
please review this

How to get the Sheet Names of an Excel File in UiPath - RPA Learners

[raja.arslankhan (Raja Muhammad Arslan khan)]

@omar_ismail
Read like this.

[fernando_zuluaga]

Hi

the idea is to use one of them, not both, as i explanied before, you can use one or other based on your requirement, if you want to retrieve the sheet name, based on the index sheet for example your first excel sheet name, then use the Get Workbook Sheet Activity and set the index value, example:

[Anil_G (Anil Gorthi)]

@omar_ismail

Inside use excel scope activity …

You can use Excel.Selectedsheet to get the sheetname of the current excel…

This can be used in read range activity sheetname field…

As there is only one sheet this will give the current sheetname directly

Hope this helps

Cheers