Converting xlsx to xls using Microsoft Office Comp

问题:

The internet says that you can convert xlsx files to xls files using Microsoft Office Compitablity like this:
"C:\Program Files\Microsoft Office\Office14\excelcnv" -nme -oice D:\test\new.xlsx D:\test\old.xls
However, this works backwards - it converts xls files to xlsx files. Does anyone know the excelcnv switches to convert xlsx to xls?

回答1:

For me, using the compatibility (conversion) pack for Office 2003, simply switching the places of the parameters in the example you cite works; e.g. if this also works for ~\Office14 (which I assume and hope it does), change the command this way:

"C:\Program Files\Microsoft Office\Office14\excelcnv" -nme -oice D:\test\old.xls D:\test\new.xlsx

In my case, the particular command that gets it to work, which I found yonder (and simply reversed the parameters like so), is this:

"C:\Program Files (x86)\Microsoft Office\Office12\excelcnv.exe" -oice "C:\scripts\test1.xls" "C:\scripts\test1.xlsx"

回答2:

I came across this question whilst looking for a way to convert XLSX to XLS using the command line. I couldn't get the solution presented here to work, but I managed to find a solution by installing Libre Office 5 then using the command:

"C:\Program Files\libreoffice 5\program\soffice.exe" --convert-to xls "original-file.xlsx"

This outputted the file as "original-file.xls"