Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Creating a copy of a file with a different format type.

XiaoDSJ
5 - Atom

Hi all,

 

I have a .xlsx file with multiple sheets that needs to be converted to a .xls file. 

It is part of a larger Alteryx+Python workflow, so manually opening the file and saving it in a different format every time is unfortunately not doable.

I have tried using the community Copy and Move Tool, however, it does not seem to work for this task.

I have also tried using python shutil.copyfile and os.rename, but the file is still being read as a .xlsx (opening the file in excel throws a warning that the file format and file extension do not match)

 

Opening the file with the "file input" tool and directly putting it into an output tool works in theory, but would have to be set up for each individual sheet in the file (of which there are many).

 

Not sure where to go from here, but I am open to python and/or Alteryx based solutions 

 

Thanks!

0 REPLIES 0
Labels