Jumbo
(Jumbo Suzuki)
September 19, 2019, 8:44am
1
Hi all,
Saving excel file as xlsx always failed… I created very simple workflow as below.
open csv file with excel
open save as window, rename file and select xlsx file type with select list item.
press save button.
I checked all selector but its fine…
(some case it saved as csv instead excel, some case pressing save button failed…)
Does anybody know similar case?
Rgds,
Natapong
(Natapong Raojutitam)
September 19, 2019, 8:56am
2
Hi @Jumbo
I would like to suggest you for easy way to convert CSV file to Excel
Your can use [Balareva.CSV.Activities] to do that.
@Shashi123
Your can use [Balareva.CSV.Activities] to do it.
[image]
At first you need to create excel file with format table that you want and input excel file path to [CSV to Excel] activity.
This activity will get data in CSV file and input it to Excel file.
Please refer to the following
[image]
for selector does not work case, you need to using wildcards and validate it by Ui Explorer.
The UiPath Documentation Portal - the home of all our valuable information. Find here everything you need to guide you in your automation journey in the UiPath ecosystem, from complex installation guides to quick tutorials, to practical business...
I hope it will be help you.
1 Like
Jumbo
(Jumbo Suzuki)
September 19, 2019, 9:13am
3
@Natapong
Thanks for your reply, as you know, I have some other way to do this,
but I’m just wondering why I cannot click save button… I suppose I can do the way with other version…
Natapong
(Natapong Raojutitam)
September 19, 2019, 9:40am
4
Hi @Jumbo
What is your program version.
I using studio version 2019.8.0 with excel 2013 and
I don’t facing any problem about selector in excel.
1 Like
Jumbo:
similar
Hi Jumbo,
2 methods:
read the csv in a datatable and save the datatable to xlsx via write range
open csv in excel
hotkey f12
Select Item ‘ComboBox’ → wnd aaname=‘Save as type:’ cls=‘ComboBox’
“Excel Workbook (*.xlsx)”
IF the Select doesn’t work you can do it with a click
and hotkey e
(but if it is already on xlsx it will chose another format starting with e)
I preffer method 1 as you don’t have to open excel at all and you can use the write range from the workbook activities.
TimK
(Tim Kok)
September 19, 2019, 10:02am
6
@Jumbo After selecting the list item, send a tab or enter key maybe as it may not take the list item before saving?
Jumbo
(Jumbo Suzuki)
September 19, 2019, 10:40am
7
@Natapong
Thanks for your confirmation, so might be my setting matter.
I’m using Microsoft office 365 Excel and it is 64 bit, perhaps it might cause… I heard something about it before…
1 Like
Jumbo
(Jumbo Suzuki)
September 19, 2019, 10:46am
8
@JoVansant @TimK
Thanks for your reply. I will check.