Save excel sheet with different names

Help Studio
, ,
1

Screenshot (26)
Screenshot (26)1600×900 133 KB

pls help me regarding this ! After downloading excel sheet how can I save as the excel workbook with different names which names are stored in read range activity of excel sheet, After seeing this pic.

2

Hi @Charan_cherry

After Downloading the excel

Enable this Show Modern

image
image305×605 14.9 KB

  1. Use Excel Scope Process activity

  2. Use Excel file and pass the file name in the field

  3. Use Rename activity

From → Excel.Sheet(“Older sheet name”)

To → New Sheetname

image

Regards
Gokul

3

sorry @Gokul001 I don’t want sheet rename I want to save as new excel workbook

4

In the Requirement you have mention that you need to rename sheet. Then you have updated it

5

Hi @Charan_cherry

Just use this Rename file activity

image

Regards
Gokul

6

Hello @Charan_cherry

If you just need to rename the file then you can use the Rename File activity. Else if you need to move it to a different location, then in the destination field provide the “folderpath\newfilename.xlsx”.

If the requirement is something different please give more clarity.

Thanks

7

if you go into settings on your browser and then into downloads you can set it to ask you for a pathway before downloading the file and you can store it wherever you choose

8

Hello @Rahul_Unnikrishnan I am downloading a time sheet with taking employee names from an excel sheet after downloaded an employee time sheet then the excel workbook should be save based on how many employees names there are in the excel sheet then save other employees names as that.