Convert Excel to ODS

Convert Excel to ODS

ODS files are created by the Calc program which is a part of the Apache OpenOffice Suite. ODS files store data that is organized in rows and columns and are formatted using the OASIS OpenDocument XML-based standard.

Aspose.Cells for Python via Java supports working ODS files. The following examples demonstrate converting Excel to an ODS file.

Direct Conversion

The simplest way to convert an Excel file to ODS is to load the workbook and save it by passing SaveFormat.ODS as the second parameter of the Workbook.save method.

The following code snippet demonstrated converting Excel directly to ODS

Save the ODS document in ODF 1.1 or 1.2 Specifications

Aspose.Cells for Python via Java supports saving ODS files in ODF 1.1 and ODF 1.2 specifications. For this, the API provides OdsSaveOptions.setStrictSchema11() property. Setting this property to true will save the file with the ODF 1.1 specification. The default value of OdsSaveOptions.setStrictSchema11() is false, so the ODS file saved without special settings is saved with ODF 1.2 specification.

The following code snippet demonstrated saving ODS files with ODF 1.1 and 1.2 specifications.