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, 2022 in Data Science by Edureka
• 13,690 points
1,242 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, 2022 by gaurav
• 23,260 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, 2022 in Data Science by Sohail
• 3,040 points
438 views
0 votes
1 answer

Using dcast to widen a data frame

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

answered Jun 24, 2022 in Data Science by Sohail
• 3,040 points
440 views
0 votes
1 answer

How to establish a connection to a remote Redash database using R?

To connect to a Redash database using ...READ MORE

answered Feb 17, 2023 in Data Science by anonymous
620 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, 2022 in Data Science by avinash
• 1,840 points
549 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, 2022 in Data Science by Sohail
• 3,040 points
1,011 views
0 votes
1 answer

Reasons for using the set.seed function

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

answered Jun 20, 2022 in Data Science by Sohail
• 3,040 points
386 views
0 votes
1 answer

plotting in different shapes using pch= argument

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

answered Jun 23, 2022 in Data Science by Sohail
• 3,040 points
459 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, 2022 in Data Science by Sohail
• 3,040 points
466 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, 2022 in Data Science by Sohail
• 3,040 points
443 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, 2022 in Database by gaurav
• 23,260 points
833 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