Calling all Racers for the Alteryx Grand Prix! It's time to rev your engines and race to the stage at Inspire! Sign up here.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.

workflow Converting .xls file to .xlsx

shankar12
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

 

3 REPLIES 3
MarqueeCrew
20 - Arcturus
20 - Arcturus

@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 restart. Order shall return.
Please Subscribe to my youTube channel.
DADE
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

LisaL
Alteryx
Alteryx

@DADE 

Does this article help?

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