How to convert .xls to .xlsx format

[ext-o]

How to convert .xls file to .xlsx format? Apparently .xls format is not readable…

---

[mkankatala (Mahesh Kankatala)]

Hi @ext-o

→ Use the Read range workbook activity to read the .xls file path and store in a datatable called dt.
→ After that use write range workbook activity to write the datatable to .xlsx file path.

Hope it helps!!

[Krishna_Raj]

@ext-o

How to convert .xls to .xlsx file

@Priyanka_Ramesh @devops @PlutoPeaM Below is the solution I was talking about, hope this gives you basic idea. In my system, following sequence works best, note below images for reference:- Step 1 → When the excel is open, to go to files (sendhotkey (ALT + F)) [Step 1] Step 2 → to export, (sendhotkey (ALT + E)) [Step 2] Step 3 → to Change file type, (sendhotkey (ALT + C)) [Step 3] Step 4 → to go to Workbook option, (sendhotkey (ALT + Q)) [Step 4] Step 5 → to click on the Work…

check the link

[lrtetala (Lakshman Reddy)]

Hi @ext-o

Try like this

Regards,

[rlgandu]

@ext-o

How to convert .xls to .xlsx file

@Priyanka_Ramesh @devops @PlutoPeaM Below is the solution I was talking about, hope this gives you basic idea. In my system, following sequence works best, note below images for reference:- Step 1 → When the excel is open, to go to files (sendhotkey (ALT + F)) [Step 1] Step 2 → to export, (sendhotkey (ALT + E)) [Step 2] Step 3 → to Change file type, (sendhotkey (ALT + C)) [Step 3] Step 4 → to go to Workbook option, (sendhotkey (ALT + Q)) [Step 4] Step 5 → to click on the Work…