Save as .xlsx

[CamiCat]

hello friends,
I have this problem.
When i try to save the file with the extension .xslx it saves it as a .txt file.

WHen I click on “Salva” it saves it as a .txt file.
How can I save it as a .xlsx file?
Thank you,
Camilla.

[ClaytonM]

Does it do this when you Save the file “manually”?
If not and the problem is with the workflow, then I would ask are you selecting the “File type” (Salva come)? Sometimes if you don’t select the type in that dropdown correctly, it will use a different file type and maybe it’s still seeing .txt even though .xlsx is selected. If that is the case, we would need to analyze the activities you are using to select that dropdown.

However, if you are not selecting the dropdown and by default it is already set to “*.xlsx”, then I am unsure what the issue is. I would also recommend trying to add the extension to the filename when you save it.

Regards.

[CamiCat]

Thank you so much @ClaytonM.
Yes, it do this when I Save the file “manually".
I’m using this activity:

but it seems that it doesn’t save the extension .xlsx selected.
CAn you please help me?
Thank you so much.
Camilla.

[balupad14 (Balamurugan)]

Hi @CamiCat,

After opened the dialog box . When you give Alt+N as hotkey. You will get the focus in the dialog box and you can type it.

Regards
Balamruugan.S

[CamiCat]

Thank you so much @balupad14.
I tried but anything happens unfortunately.

Can you pleas help me with a workflow?
Thank you so much,
Camilla

[balupad14 (Balamurugan)]

Yes @CamiCat. I will send you…

[CamiCat]

Thank you @balupad14.
I’ll wait for your kind answer.
Camilla

[balupad14 (Balamurugan)]

before

File : ExcelSaveAs.zip (77.5 KB)

after

Note : Please change the Attach window selector to some excel file opened.

Regards
Balamurugan.S

[CamiCat]

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

[ClaytonM]

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.

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