Support Portal

for ProcessRobot and WinAutomation

Start a new topic

Convert excel file format xls to xlsx

Hi,

I have some reports arriving to me in xls format, but I would like winautomation to automatically convert format to xlsx. 


Any idea? Many thanks!


ADMIN

Hi, Sergiu.


There are multiple ways to perform this tasks:

(i) Through Excel actions - Open each file and rename it.

(ii) Through VBscript


Without opening the file, you can rename it through Command prompt using "REN" command.

Syntax: Ren [full path including the file extension] [new filename/extension]

Eg: Ren C:\Users\ABC\Desktop\Example_Sheet.xlsx Example_Sheet.xls


I hope this helps in resolving your issue.



Open them one at a time and save them as the new preferred format.


Find me on LinkedIn if you need instruction :)

Login or Signup to post a comment