Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

workflow Converting .xls file to .xlsx

Highlighted
8 - Asteroid

i have around 80 .xls files which i need a workflow to change them to .xlsx means need to convert like save as .xlsx.

 

Thanks

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@shankar12,

 

Ultimately, you are wanting to use this command line tool:  excelcnv.exe

 

"C:\Program Files (x86)\Microsoft Office\Office15\excelcnv.exe" -oice "C:\in\MyFile.xls" "C:\out\MyFile.xlsx”

 

If this is a one-time need, just run something like this from your cmd window.  Otherwise, you can befriend the Run Command tool or use an Event to run this task.

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
6 - Meteoroid

I am trying to make this solution work through the run command tool for all files in a folder and I cant seem to make it work.

 

Command : 

 

for %F in (*.xls) do "C:\Program Files (x86)\Microsoft Office\Office15\excelcnv.exe" -nme -oice "%~fF" "%~fF"x

Labels