Batch Conversion .ods to. xlsx

Discuss the spreadsheet application

Batch Conversion .ods to. xlsx

Postby John008 » Tue Sep 12, 2017 9:27 am

Hi All

I have bunch of 50 to 100 .ods files. I need to convert .ods to .xls file formate, Is there any open office macro or VBA macro to convert these .ods files.

Thanks
John
OpenOffice 3.1 on Windows Vista / NeoOffice 2.2.3 with MacOS 10.4 / OpenOffice 2.4 on Ubuntu 9.04
Locale: en-US (en_US); Calc: group
John008
 
Posts: 2
Joined: Tue Sep 12, 2017 9:19 am

Re: Batch Conversion .Ods to. xlsx

Postby Zizi64 » Tue Sep 12, 2017 10:05 am


Batch Conversion .Ods to. xlsx

postby John008 » 2017 Sep 12, 9:27 am
Hi All

I have bunch of 50 to 100 .ods files. I need to convert .ods to .xls file formate, Is there any open office macro or VBA macro to convert these .ods files.


The .xlsx anrd the .xls are basicly different file formats. The .xlsx format is descripted in the OOXML Standard. It has two main versions: The Strict and the Transitional.
The .xls filformat never was standardized, and it has many different subversions.

The AOO can not save into the OOXML fileformats.
The LibreOffice can, but it can save into the Strict version of the OOXML Standard, the MS Office supports (by default) the Transitional version of the Standard (because they can change it when they want it to do).

Never was (and never will be) 100% compatibility between the different fileformats. You will lost some formatting and other properties at every conversion.


Conclusion: always use the International Standard ODF fileformats.
OtherWise the AOO and LO has a batch conversion wizard to ODF format...
Tibor Kovacs, Hungary; LO4.4.7, LO5.3.7 on Win7x64Prof.
PortableApps, WinPenPack: LO3.3.0-LO5.4.2 and AOO4.1.3
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 6008
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Batch Conversion .Ods to. xlsx

Postby John_Ha » Tue Sep 12, 2017 10:58 am

See [Tutorial] Differences between Writer and MS Word files for why you should always work in and save files as .odt.
AOO 4.1.4, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the up to date Writer guide for information. Click the Help button on a pop-up window for extensive help on that function.
John_Ha
Volunteer
 
Posts: 4546
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Batch Conversion .Ods to. xlsx

Postby John_Ha » Tue Sep 12, 2017 10:58 am

See [Tutorial] Differences between Writer and MS Word files for why you should always work in and save files as .odt. It applies even more so to spreadsheets where the differences are greater.
AOO 4.1.4, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the up to date Writer guide for information. Click the Help button on a pop-up window for extensive help on that function.
John_Ha
Volunteer
 
Posts: 4546
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Batch Conversion .Ods to. xlsx

Postby RoryOF » Tue Sep 12, 2017 11:01 am

Note also that macros in .ods files will not work in .xls formats,
Apache OpenOffice 4.1.4 on Xubuntu 16.04.03 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 25394
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Batch Conversion .ods to. xlsx

Postby MrProgrammer » Wed Sep 13, 2017 6:59 pm

John008 wrote:I have bunch of 50 to 100 .ods files. I need to convert .ods to .xls file format
Why? Any recent version of Microsnot Office can open .ODS files.
Mr. Programmer
OpenOffice 3.2.0 Build 9483 on Mac OS X 10.9.5.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Volunteer
 
Posts: 3111
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Batch Conversion .ods to. xlsx

Postby John008 » Thu Sep 14, 2017 7:47 am

I have only Mircrosoft Office 2007 version . Is there any possibilities to convert .ods to .xls file format
OpenOffice 3.1 on Windows Vista / NeoOffice 2.2.3 with MacOS 10.4 / OpenOffice 2.4 on Ubuntu 9.04
Locale: en-US (en_US); Calc: group
John008
 
Posts: 2
Joined: Tue Sep 12, 2017 9:19 am

Re: Batch Conversion .ods to. xlsx

Postby Zizi64 » Thu Sep 14, 2017 7:56 am

I have only Mircrosoft Office 2007 version .


That is a 10 years old software... :shock:
Tibor Kovacs, Hungary; LO4.4.7, LO5.3.7 on Win7x64Prof.
PortableApps, WinPenPack: LO3.3.0-LO5.4.2 and AOO4.1.3
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 6008
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Batch Conversion .ods to. xlsx

Postby RusselB » Thu Sep 14, 2017 4:14 pm

@John008: It is possible to convert .ods to .xls however you must be prepared for the possibility of formatting and/or data being lost in the conversion process.
If you don't have a lot of files, simply open the .ods file in Calc, then use File -> Save As (and follow the dialogs that come up to select the correct format you want to save in)
If you have a lot of files, then you might want to consider using Zamzar for the conversion process
OpenOffice 4.1.4 and LibreOffice 5.2.7.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
RusselB
Volunteer
 
Posts: 4118
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Batch Conversion .ods to. xlsx

Postby MrProgrammer » Thu Sep 14, 2017 7:18 pm

John008 wrote:I have only Mircrosoft Office 2007 version . Is there any possibilities to convert .ods to .xls file format?
Why? Just install ancient service pack 2 if you didn't eight years ago.
Microsnot wrote:The 2007 Microsoft Office system will support XML Paper Specification (XPS), Portable Document Format (PDF) 1.5, PDF/A and Open Document Format (ODF) v1.1 with the release of Microsoft Office 2007 Service Pack 2 (SP2), scheduled for the first half of 2009.
News: Microsnot Office to get ODF, PDF support

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
OpenOffice 3.2.0 Build 9483 on Mac OS X 10.9.5.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Volunteer
 
Posts: 3111
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA


Return to Calc

Who is online

Users browsing this forum: No registered users and 24 guests