Converting xlsx to xls using Microsoft Office Compitablity Pack s excelcnv

0 votes
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?
Mar 23 in Data Science by Edureka
• 9,320 points
44 views

1 answer to this question.

0 votes
Simply rearranging the positions of the parameters in the example you quote works for me when using the compatibility (conversion) pack for Office 2003; for example, if this also works for Office14 (which I expect and hope it does), modify the command to:

"C:Program FilesMicrosoft OfficeOffice14excelcnv" -nme -oice "C:Program FilesMicrosoft OfficeOfficeOffice14excelcnv" -nme -oice "C:Program FilesMicrosoft OfficeOffice14 D:\test\old.xls D:\test\new.xlsx
In my situation, the command that gets it to function is this:

-oice "C:scriptstes" -oice "C:Program Files (x86)Microsoft OfficeOffice12excelcnv.exe"
answered Mar 25 by Edureka
• 8,820 points

Related Questions In Data Science

0 votes
1 answer

Importing Excel files into R, xlsx or xls

To get started, here's a template for ...READ MORE

answered Mar 30 in Database by Edureka
• 8,820 points
17 views
0 votes
1 answer

Unable to compress excel file (XLSX or XLS) using java

Because the formats with a 'x' at ...READ MORE

answered Apr 11 in Database by Edureka
• 8,820 points
46 views
+1 vote
1 answer

Converting a date string to a DateTime object using Joda Time library

Use DateTimeFormat: DateTimeFormatter formatter = DateTimeFormat.forPattern("dd/MM/yyyy HH:mm:ss"); DateTime dt = ...READ MORE

answered Jul 24, 2018 in Java by scarlett
• 1,290 points
3,357 views
+1 vote
2 answers

Python convert XLS and XLSX file to csv

XLSX tables are usually created in MS ...READ MORE

answered Aug 30, 2019 in Python by Mian Tanzeel
14,512 views
0 votes
1 answer

How to read a .xlsx file using the pandas Library in iPython?

Every sheet gets its own DataFrame, which ...READ MORE

answered Mar 25 in Database by anonymous
24 views
0 votes
1 answer

Convert .xlsb to .xlsx - Multi-sheet Microsoft Excel File

xlsb can be read by newer versions ...READ MORE

answered Mar 30 in Database by Edureka
• 8,820 points
72 views
0 votes
0 answers
0 votes
1 answer

Converting Excel Date Serial Number to Date using Javascript

Please do try this : function ExcelDateToJSDate(serial) { ...READ MORE

answered Apr 11 in Database by Edureka
• 8,820 points
35 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP