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

Help StudioX
,
1

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

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

image
image640×739 19.3 KB

image

2

Hi @Joshua_Ducao,

Try this.

sheetsVariable(sheetsVariable.count).Tostring

Or

sheetsVariable.Last

Hope it helps.

1 Like
3

Hi @Joshua_Ducao ,

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?

1 Like
5

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

6

Thanks sheets.LastOrDefault works

7

Thanks for the solution

1 Like
8

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

9

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