How to Display in textbox the last sheet in excel if we use get workbook sheets activity

Joshua_Ducao · April 9, 2023, 7:07am

in the picture, i would like to get the April 7 to be displayed in the text box

Harshith_Adyanthaya · April 9, 2023, 7:12am

Try this.

sheetsVariable(sheetsVariable.count).Tostring

Or

sheetsVariable.Last

Hope it helps.

Manish540 · April 9, 2023, 7:13am

Please add this below code in message box,
sheets.LastOrDefault

where, sheets → Output of the Get Workbook Sheets activity.

And let us know if its working for you?

Joshua_Ducao · April 9, 2023, 4:28pm

sheetsVariable.Last Works but sheetsVariable(sheetsVariable.count).Tostring doesn’t, like it looking for a range of sort.

Joshua_Ducao · April 9, 2023, 4:28pm

Thanks sheets.LastOrDefault works

Joshua_Ducao · April 9, 2023, 4:29pm

Thanks for the solution

Harshith_Adyanthaya · April 9, 2023, 4:40pm

My bad, it should be sheetsVariable(sheetsVariable.count - 1).Tostring

system · April 12, 2023, 4:40pm

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