Hello,
I am newbie and I am trying to save a CSV type to XLSX but when it comes to Save As window. It throws this error
Click ‘list item’: Could not find the UI element corresponding to this selector:
[1]
[2]
Search failed at selector tag:
[1]
The closest matches found are:
[66%]
This is how my selector looks like. Sometimes it works but most of the time it throws the error above.
Any suggestion?
Thanks.
UI Automation is not how you work with these files.
Use Read CSV to read the data into a datatable.
Use Excel Process Scope, with Use Excel File, with Write Range to write to .xlsx
Hi @julian.moreno ,
2 solution for you
1.You can use rad CSV file to get data
Use write range to paste data to Excel file.
2.You can use invoke VB code
Can you share your CSV?
I will test it
Hi,
Can you try as the following sample using UseExcelFile and SaveExcelFileAs?
Sample20230810-2L.zip (2.7 KB)
Regards,
Thank you all. I will try all your suggestions and see what works for me. I truly appreciate the help.
