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 keep the specified sheet in excel? Activities excel , activities , studio , question , workflow_diff	7	42	August 28, 2024
How to get Excel Sheet name? Activities excel	3	6325	May 11, 2022
Hidden sheets in Excel Studio studio , question , activities_panel	3	290	August 24, 2023
Get the sheetname by searching a particular word in all sheets of excel file Activities excel , studio	4	25	July 23, 2024
Get sheet names from Excel file which stored in Google drive Studio studio , question , activities_panel	4	685	August 3, 2022

Most Active Users - Yesterday
sonaliaggarwal47
A_Learner
sharazkm32
More details...

How to only the last sheet name in an excel file

Related topics