Rename File from xlsm to xlsx

Help Studio
, ,
1

Hi I have a xlsm file in which after modification and adding some data I need to rename the file with the extension xlsx.
But if I am using rename file option it is renaming the file but while opening the file it is showing that the file is corrupt.
Can anyone suggest how to do it??

2

@Kunal_Jain

Please use save excel file as activity

https://docs.uipath.com/activities/docs/save-excel-file-as-x

Cheers

3

Hi @Kunal_Jain

By changing the file name the xlsx file will not change to xlsm file.
You have to change the extension of the file. Use the “save excel file” as activity in the save as type option in the dropdown select the .xlsm. check the below image for more clarification.
MicrosoftTeams-image (2)

Hope it helps!!

4

hi @Kunal_Jain

You cannot directly change the file extension using rename functionality, that would definitely make the file corrupted.

You would have to use Save Excel File as, and in there you have to select the format to do this.
image

If it has only 2-3 sheets that you want to use,
Create a new excel file:
by Reading the sheets from .xlsm file and using write range in the .xlsx file to insert the datatables read.

Thanks,
Happy Automation! :smiley:

5

In which package we will find this activity??

6

@Kunal_Jain

This is in excel activities itself…modern excel activities…attached the link for your reference

Cheers

7

HI @Kunal_Jain

You will find these activities under the Package UiPath.Excel.Activities.
Hope it helps!!
Regards,

8

Well I am not using Modern Design Experience

9

Then you can try searching for a package called as UiPath.ComplexScenarios.Activities

Its from UiPath itself.

10

@Kunal_Jain

Even then you can use modern activities

Activities → filter icon → show modern

Cheers