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,600 points
71 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
• 12,420 points

Related Questions In Data Science

0 votes
0 answers

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

Is there a website to which I ...READ MORE

5 days ago in Data Science by Avinash
• 1,060 points
5 views
0 votes
0 answers

Using dcast to widen a data frame

I've got the following data set: z - ...READ MORE

5 days ago in Data Science by Avinash
• 1,060 points
4 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
• 760 points
19 views
0 votes
0 answers

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

The question concerns the practical difference between ...READ MORE

Jun 1 in Data Science by avinash
• 760 points
13 views
0 votes
0 answers

Reasons for using the set.seed function

Many times I have seen the set.seed ...READ MORE

Jun 1 in Data Science by avinash
• 760 points
12 views
0 votes
0 answers

plotting in different shapes using pch= argument

How can we assign a particular shape ...READ MORE

Jun 2 in Data Science by avinash
• 760 points
17 views
0 votes
0 answers

How To Create Vector of Vector In R

have lines like this in your supplied ...READ MORE

Jun 10 in Data Science by Avinash
• 1,060 points
10 views
0 votes
0 answers

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

Let's pretend we have a data frame ...READ MORE

Jun 10 in Data Science by Avinash
• 1,060 points
6 views
0 votes
0 answers

Add two lines on graph using abline in R

I'm working with two variables: x=rnorm(10, 5, 1) ...READ MORE

Jun 13 in Data Science by Avinash
• 1,060 points
4 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
• 12,420 points
32 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