Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!

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.
Highlighted
7 - Meteor

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

Highlighted
Alteryx
Alteryx

@DADE 

Does this article help?

Lisa LePome
Senior Customer Support Engineer -- Knowledge Management Coach
Alteryx, Inc.
Labels