Page 1 of 1
Batch Conversion .ods to. xlsx
Posted: Tue Sep 12, 2017 9:27 am
by John008
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
Re: Batch Conversion .Ods to. xlsx
Posted: Tue Sep 12, 2017 10:05 am
by Zizi64
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...
Re: Batch Conversion .Ods to. xlsx
Posted: Tue Sep 12, 2017 10:58 am
by John_Ha
See
[Tutorial] Differences between Writer and MS Word files for why you should always work in and save files as .odt.
Re: Batch Conversion .Ods to. xlsx
Posted: Tue Sep 12, 2017 10:58 am
by John_Ha
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.
Re: Batch Conversion .Ods to. xlsx
Posted: Tue Sep 12, 2017 11:01 am
by RoryOF
Note also that macros in .ods files will not work in .xls formats,
Re: Batch Conversion .ods to. xlsx
Posted: Thu Sep 14, 2017 7:47 am
by John008
I have only Mircrosoft Office 2007 version . Is there any possibilities to convert .ods to .xls file format
Re: Batch Conversion .ods to. xlsx
Posted: Thu Sep 14, 2017 7:56 am
by Zizi64
I have only Mircrosoft Office 2007 version .
That is a 10 years old software...
Re: Batch Conversion .ods to. xlsx
Posted: Thu Sep 14, 2017 4:14 pm
by RusselB
@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