Hello All, a small help needed
I want to rename a sheet with the data which is there in that sheet A1.
For example- in a excel file Input.xlsx, in sheet1 the string data in A1 is “Profit”
My bot should rename the sheet name from sheet1 to Profit… How to do it?
Excuse my Typos
Thanks
I have more than 1 sheet and I want to do it for each one!!!
Create a list or array and give sheetnames
Take for each
In “To” section in rename:Give Currentitem
Use the below workflow and take the variables as below mentioned data types.
Hope it helps!!
Step 1 => Take Use excel file activity and give the path of the excel file
Step 2 => Inside use Excel file activity insert the read cell activity to read the cell A1 in range give like below.
Excel.Sheet(“Sheet1”).Cell(“A1”)
Store the output in a string variable.
Step 3 => after read cell insert the rename sheet activity.
Give the range Excel.Sheet(“Sheet1”) in from field.
Pass the String variable in to field in rename sheet activity.
Hope it helps!!
@Yoichi
@vrdabberu
Thanks for the solution.
Both the solution are easier to understand and fulfills my requirement,
but marking only one as solution for thread closure.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
