At the top of the list for users who've spent their working lives with Microsoft Office, the best feature is better compatibility with DOCX, XLSX, and PPTX files. This new major release comes with several improvements. Oh, and did I mention? LibreOffice won't cost you a cent. But, if you want an old-style office suite which lives on your PC, LibreOffice is now your top choice. Maybe paying an eternal subscription fee for Microsoft works for you. As a "last resort" - Microsoft's words, not mine - Microsoft recommends Office 2019. Microsoft has made it clear that it sees the desktop office suite future on the cloud, not on your PC. n()įilename, file_extension = os.path.splitext(file)ĭata.append(os.path.join(PATH, filename, file_extension.lower().How to add new users to your Linux machine # 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |