I want to change the file format from .xls to .xlsx as read range activity is enable to read the .xls version it might be because I am working on UiPath 2018 version.
I have tried using move file to convert to .xlsx but in that case file is getting corrupted.
You’d have to open it in Excel and then “save as” it, selecting a different format.
You can use Excel Application Scope create the .xlsx
Then, use Excel Application Scope and Read Range read the .xls and it will output a DataTable
Final, use Excel Application Scope and Write Range write into .xlsx
I am not able to read .xls file using read range
Hi @Karan28 ,
You might have to use invoke code to open the .xls and save it as XLSX
Could you please explain me how would I achieve that ?