Hello,
In my process the application I’m working with generates an Excel file with .xls extension (old excel file version). I cannot use Excel steps because they require the .xlsx version. Is there some easy way that I can convert the format from .xls to .xlsx?
Thanks!
- tihanaM asked 10 months ago
- You must login to post comments
Hi,
If you have MS Office installed on the machine it comes with an command line converter that is easily used. So add Execute Command Prompt Step and call:
“C:\Program Files (x86)\Microsoft Office\Office15\excelcnv.exe” -oice “C:\in\MyFile.xls” “C:\out\MyFile.xlsx”
Of course replace the paths with full path to your Excel file or variables.
*Note: The path to excelcnv.exe might be different depending on the Office version and also it might be in Program Files folder without the (x86). Maybe the best way is to search for it in Windows explorer.
- Darko Jovišić answered 10 months ago
- You must login to post comments
Please login first to submit.