Unified Office Format Spreadsheet (*.uos) - This is a special spreadsheet format that uses an open standard. However, the file is an uncompressed single file. Then, users can use the started template to make the final ODF Spreadsheet.įlat XML ODF Spreadsheet (*.fods) - This is nearly the same as an ODF Spreadsheet (*.ods). Users can make a template for a frequently used format that is planned to be used in many documents. n()įilename, file_extension = os.path.splitext(file)ĭata.append(os.path.join(PATH, filename, file_extension.lower().ODF Spreadsheet Template (*.ots) - This is a template file for ODF Spreadsheets (*.ods) that uses the "application/-template" mimetype. # 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)
