We can mention the sheetname only as a string buddy with the activities we have in uipath
May be we can get the sheetname from arr_sheets = workbookvariable.GetSheets.ToArray()
Where arr_sheets is a variable of type array of string
And workbookvariable can be obtained from EXCEL APPLICATION SCOPE workbook property in its property panel
And now pass this array variable to For each activity
And mention the sheetname as item.ToString with Reda cell activity inside the for each loop
But I don’t use Excel Scope Activity… I used For Each activity only to read one by one xls files in one folder… And I want to get “Sheet1” as below picture instead of Name of Sheet.
I can do this with one excel file… but don’t know how to do in this case
Hi Bro.
in Read Range, I don’t want to call Name of Sheet as below picture because xls files have name of sheet are different… I want to call Sheet Index “Sheet1”
My workflow has problem when i run… it is conflicted between For Each acitivity and Excel Scope activity… when i run it show alert “ the file xxxx is being opened “…
So, i have used VB script to change sheet name :)!