Hi, I am using a Read Range activity to read an excel sheet. But the sheet name changes every month. let say this month its “August” and Next month the sheet name will be “September” like that. How can we use the code without changing the sheet name in the Read Range activity everytime. Regards,

hey @raju_alakuntla U can use get workbook sheets activity Which will give you all the sheet names of the excel/Workbook And then iterate through the sheet and do stuffs or there is an Get workbook sheet where u have to give the index and it will return the sheet name present in that index posit…

How to change the excel sheet names

Help Studio

Nguyen_Van_Luong1 (Nguyen Van Luong) August 17, 2023, 9:10am 8

Hi @raju_alakuntla ,
You can use get work sheet to get sheet name
It need index of sheet
in excel index from 0 is first sheet

regards,
LNV

Topic		Replies	Views
Get sheet index instead name read range Academy Feedback studio	3	4262	March 25, 2021
Sheet that always changes the name Help	6	2703	May 25, 2018
Get Sheet Name & Put in Read Range Activity "Sheet Name" Help excel , question	2	942	July 22, 2020
To get Excel Sheet Name Activities excel , activities , question	3	43	December 9, 2024
How to get Excel Sheet name? Activities excel	3	6346	May 11, 2022

Most Active Users - Yesterday
ashokkarale
sonaliaggarwal47
anjasing
mkankatala
Anil_G
manasrlenka25
A_Learner
SorenB
balaraman.ramiya
sharazkm32
More details...

How to change the excel sheet names

Related topics