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
• 13,640 points
250 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 gaurav
• 22,040 points

Related Questions In Data Science

0 votes
1 answer

How to implement Knn-algorithm without using k-nn function in r?

I created an example that demonstrates the ...READ MORE

answered Jun 24 in Data Science by Sohail
• 2,960 points
47 views
0 votes
1 answer

Using dcast to widen a data frame

> dcast(z, id ~ item, value.var="freq") ...READ MORE

answered Jun 24 in Data Science by Sohail
• 2,960 points
55 views
0 votes
0 answers

Introduction to Statistical Learning with Applications in R Figure Codes

I recently bought the following book: An Introduction ...READ MORE

Jun 1 in Data Science by avinash
• 1,840 points
121 views
0 votes
1 answer

How to make loop for one-at-a time logistic regression in R?

You're probably looking for something similar to ...READ MORE

answered Jun 20 in Data Science by Sohail
• 2,960 points
284 views
0 votes
1 answer

Reasons for using the set.seed function

The requirement is a desire for repeatable ...READ MORE

answered Jun 20 in Data Science by Sohail
• 2,960 points
49 views
0 votes
1 answer

plotting in different shapes using pch= argument

plot(Sepal.Length ~ Petal.Length, ...READ MORE

answered Jun 23 in Data Science by Sohail
• 2,960 points
69 views
0 votes
1 answer

How To Create Vector of Vector In R

Create a list: List() on x returns x[[1]] ...READ MORE

answered Jun 24 in Data Science by Sohail
• 2,960 points
60 views
0 votes
1 answer

Why is it not advisable to use attach() in R, and what should I use instead?

There is one more option that applies ...READ MORE

answered Jun 24 in Data Science by Sohail
• 2,960 points
37 views
0 votes
1 answer

Add two lines on graph using abline in R

I am using "y 0+x" to fit ...READ MORE

answered Jun 24 in Data Science by Sohail
• 2,960 points
80 views
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 gaurav
• 22,040 points
89 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP