Save as .xlsx

Help
21

Hi @CamiCat,

I have uploaded an activity to rename the excel sheet

Special thank to you.Gave this idea to create.

Regards
Balamruugan.S

2 Likes
22

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

image
image1600×900 65.1 KB

Camilla :slight_smile:

23

HI @CamiCat,

Sorry to mention the name space in the post.

image

Regards
Balamurugan.S

1 Like
24

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

image
image1600×900 88.4 KB

Thank you,
Camilla :slight_smile:

25

Hi @CamiCat,

Can you please click the Available

image

Regards
Balamurugan.S

1 Like
26

image
image1600×900 102 KB

I cannot find it in the list :frowning:
Sorry for the disturb :slight_smile:

27

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.

image
image756×774 56.6 KB

Please follow the red mark

image
image994×613 41.6 KB

Regards
Balamurugan.S

1 Like
28

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

image
image1600×900 102 KB

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

29

Hi @CamiCat ,

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

Regards
Balamurugan.S

1 Like
30

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 :slight_smile:

31

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

1 Like
32

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

image
image1600×900 84.3 KB

Thank you,
Camilla :slight_smile:

33

Hi @CamiCat,

Which version MS office you are using ?

Regards
Balamurugan.S

1 Like
34

hello @balupad14.
Excel 2016.

35

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

1 Like
36

Sorry @balupad14.
I have no possibilty to make you install a trial version of Office 2016.
i have Excel 2016 installed on the customer’s server.
Sorry :sweat:

37

HI @CamiCat,

I can do one thing. I do the same thing in Invoke Code activity in a xml and send it to you. We easily identify the problem. But I need time to do the thing…

Regards
Balamurugan.S

1 Like
38

Thank you so much @balupad14.
Camilla :slight_smile:

39

Hi,

Can you share the custom activity so we can add in package, Thanks

40