Save as .xlsx

Thank you so much @balupad14.
The problem is that I start from a .csv file and I should save it as a .xlsx.


I should choose the .xlsx type from the dropdown list
and then save
Can you please help me further?
Thank you so much,
camilla :slight_smile::grin:

I don’t know if you have already thought of this, but you could take the Data Table from the CSV file (Read CSV), then use Write Range with that Data Table and you can save it to a new .xlsx file.

2 Likes

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

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

1 Like

Hi @CamiCat,

I saw some thing different .

Regards
Balamurugan.S

HI @CamiCat

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

Regards
Balamurugan.S

1 Like

Thank you so much.
It seems working :slight_smile:
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

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

This one will help you to rename the excel sheet.

Regards
Balamurugan.S

1 Like

Hi @CamiCat,

A surprise is waiting for you !!!

Regards
Balamurugan.S

1 Like

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

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

1 Like

Thank youuu @balupad14::tada::tada::tada:

1 Like

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

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


Camilla :slight_smile:

HI @CamiCat,

Sorry to mention the name space in the post.

image

Regards
Balamurugan.S

1 Like

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


Thank you,
Camilla :slight_smile:

Hi @CamiCat,

Can you please click the Available

Regards
Balamurugan.S

1 Like


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

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

1 Like

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