How to change the file format

Help Studio
, ,
1

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.

Please help

2

You’d have to open it in Excel and then “save as” it, selecting a different format.

3

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

4

I am not able to read .xls file using read range

5

Hi @Karan28 ,

You might have to use invoke code to open the .xls and save it as XLSX

6

Could you please explain me how would I achieve that ?