Save as .xlsx

[Niket_Ghai]

Yes as @ClaytonM said, this method seems to be fine.

[balupad14 (Balamurugan)]

Yes @CamiCat. Doing hot key method . Better we can read the data from csv to Datatable and you can write into an excel as @ClaytonM said.

Regards
Balamurugan.S

[balupad14 (Balamurugan)]

Hi @CamiCat,

I saw some thing different .

Excel Save As Type Combo box

I managed to resolve it thanks to @Uemoe using the Export window in Excel. [image] Quite a lot of steps and I don’t know yet why the combo box is not working

Regards
Balamurugan.S

[balupad14 (Balamurugan)]

HI @CamiCat

Another one i have seen in the excel to save in a different way as below

Regards
Balamurugan.S

[CamiCat]

Thank you so much.
It seems working
1)How is it possible to close the excel file so that I can can processthem one after the other?
2)And is it possible to change the name of the Excel sheet?

Thank you so much,
Camilla

[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