Hi, I need to get only the last sheet name in an excel file, as per the process at every run a new sheet will added at the last. Is that possible to get only the last sheet name and proceed further instead of going to all sheets?

Hi @Prasaanth_S2 Chek the below steps, → Use the Excel application scope and give the path of the excel file. → Inside Excel application scope activity insert the Get workbook sheets activity and create a variable in the Sheets field in properties as List_Sheets. → Then use the below expressi…

How to only the last sheet name in an excel file

Help Activities

rlgandu (Rajyalakshmi Gandu) July 12, 2024, 7:41am 2

@Prasaanth_S2

Excel Application Scope
Get Workbook Sheets
Output: sheetNames (List<String>)
lastSheetName = sheetNames(sheetNames.Count - 1)

1 Like

Topic		Replies	Views
How to get Excel Sheet name? Activities excel	3	5366	May 11, 2022
Hidden sheets in Excel Studio studio , question , activities_panel	3	268	August 24, 2023
Get sheet names from Excel file which stored in Google drive Studio studio , question , activities_panel	4	674	August 3, 2022
Unhide sheet in excel Help studio , question	1	867	December 23, 2020
Excel get sheets activity Help excel , activities , question	11	1110	January 10, 2020

Most Active Users - Yesterday
mkankatala
ashokkarale
ppr
Guru_Koli21
supermanPunch
Anil_G
akashjariwala
mojo001
Ramya_25
tharani.natarajan
More details...

How to only the last sheet name in an excel file

Related Topics