# loop files, convert and get converted filename for outputting PATH = Alteryx.getWorkflowConstant('Engine.WorkflowDirectory') + "Data"ĮXE = 'C:\Program Files\LibreOffice\program\soffice.exe'
# path with files to convert (assume in Data subdirectory to workflow) "C:\Program Files\LibreOffice\program\soffice.exe" -convert-to xlsx "C:\input_path\file.xls" -outdir "C:\output_path"Īnd sample python code that does the conversion looks like this outputting the converted files in a dataframe. I've written full details of the solution here that includes either using the run command or python code to be included in the python tool. Turns out that LibreOffice can be run in batch conversion mode without any UI and it converts xls to xlsx (as well as doc to pdf and other conversions)
After seeing various posts about converting xls to xlsx that either involve loading the files into Alteryx and then saving or alternatively using an executable that's part of the Excel installation I wanted to look for an alternative that was free and efficient.
0 kommentar(er)
