Save as .xlsx

[balupad14 (Balamurugan)]

Above you have lot suggestion. which one is a solution to you ?

This one will help you to rename the excel sheet.

Excel renaming

Hi, i have one excel file with mutiple sheets Want to rename the sheets name [excel_sheet] want to change as these names(As names may add…so have to dynamic) [excel_rename] How we can try?Is there any activity

Regards
Balamurugan.S

[balupad14 (Balamurugan)]

Hi @CamiCat,

A surprise is waiting for you !!!

Regards
Balamurugan.S

[CamiCat]

Thank you @balupad14.
Which kind of surprise?
I’m trying to change the xcel sheet name.
Camilla

[balupad14 (Balamurugan)]

That(Renaming sheet name) is the surprise @CamiCat . Wait for few minutes I am uploading the activity in the gallery. you can use it without doing many stuff.

Regards
Balamurugan.S

[CamiCat]

Thank youuu @balupad14:

[balupad14 (Balamurugan)]

Hi @CamiCat,

I have uploaded an activity to rename the excel sheet

BalaReva.Excel.Activities

Hi Friends, I have included a new activity that to rename the excel sheet’s name. “Rename Work Sheet.” Namespace : [image] Properties: [image] Sample File : RenameExcelSheet.zip (38.8 KB) Let me if you have any errors. I would be happy to get more suggestions . Regards Balamurugan

Special thank to you.Gave this idea to create.

Regards
Balamruugan.S

[CamiCat]

Thank you so much @balupad14.
Can you give me the address to find your activity?
Thank you so much,

Camilla

[balupad14 (Balamurugan)]

HI @CamiCat,

Sorry to mention the name space in the post.

Regards
Balamurugan.S

[CamiCat]

I’ve tried in this way but cannot find it.

Thank you,
Camilla

[balupad14 (Balamurugan)]

Hi @CamiCat,

Can you please click the Available

Regards
Balamurugan.S

[CamiCat]

I cannot find it in the list
Sorry for the disturb

[balupad14 (Balamurugan)]

Hi @CamiCat,

Some times I have this problem. Please close the studio. go to %Temp% folder . It has folder nuget. Inside it has all the packages folder. Delete package folder . Open the studio. I will come fresh.

Please follow the red mark

Regards
Balamurugan.S

[CamiCat]

I found your activity.
But it doesn’t work.

I would like to change the name of this sheet to “Foglio1”.
Can you help me please once more?
Thank you so much,
CAmilla

[balupad14 (Balamurugan)]

Hi @CamiCat ,

Can you give the Current Sheet name and new sheet name. I will test it here.

Regards
Balamurugan.S

[CamiCat]

Arricchimento_2018_07_19_194059.xlsx (20.8 KB)
In the file name there is the old sheet name, the new shoud be “Foglio1”.
Thank you,
Camilla

[balupad14 (Balamurugan)]

Hi @CamiCat,

It is working for me. Below I have attached file with output.

RenameSheet-1.zip (20.8 KB)

Note: Change the file path.

Regards
Balamurugan.S

[CamiCat]

I tried but it doesn’t work in my case.
Can you please help me further?

Thank you,
Camilla

[balupad14 (Balamurugan)]

Hi @CamiCat,

Which version MS office you are using ?

Regards
Balamurugan.S

[CamiCat]

hello @balupad14.
Excel 2016.

[balupad14 (Balamurugan)]

HI @CamiCat,

I am using Excel 2010. Do you know any possibilities to install something a trial version of Excel 2016 to test. I have the virtual machine.

Regards
Balamruugan.S