HTML JPG PDF XML XLSX
  Product Family
ODS

Create ODS File in C++

Native and high performance ODS file creation programmatically without Micorsoft Office using C++ library.

Create ODS File Using C++

How to create ODS file? With Aspose.Cells for C++ library, you can easily Create ODS file programmatically with a few lines of code. Aspose.Cells for C++ is capable of building cross-platform applications with the ability to generate, modify, convert, render and print all Excel files. C++ Excel API not only convert between spreadsheet formats, it can also render Excel files as images, PDF, HTML, ODS, CSV, SVG, JSON, WORD, PPT and more, thus making it a perfect choice to exchange documents in industry-standard formats. You can download its latest version directly, just open NuGet package manager, search for Aspose.Cells.Cpp and install. You may also use the following command from the Package Manager Console.

Command


PM> Install-Package Aspose.Cells.Cpp

How to Create ODS in C++

It is easy for the developers to create, load, modify and convert ODS files within running reporting applications for data processing in just few lines of code.

  1. Create an object of the Workbook class.
  2. Get the first sheet into a Worksheet object.
  3. Use Worksheet.GetCells() method to get the cells of the worksheet into a Cells object.
  4. Use Cells.Get() method to access the desired cell of the worksheet into a Cell object.
  5. Use Cell.PutValue() method to input value into the cell.
  6. Save the workbook as .ods file using Save() method.
 

Sample code shows how to create ODS file in C++.

Aspose::Cells::Startup();

// Create an object of the Workbook class.
Workbook wkb;
// Get the first sheet into an Worksheet object.
WorksheetCollection wsc = wkb.GetWorksheets();
Worksheet ws = wsc.Get(0);


// Use Worksheet.GetCells() method to get the cells of the worksheet into an Cells object.
Cells cells = ws.GetCells();


// Use Cells.Get() method to access the desired cell of the worksheet into an Cell object.
Cell cell00 = cells.Get(0, 0);
Cell cell01 = cells.Get(0, 1);
Cell cell10 = cells.Get(1, 0);
Cell cell11 = cells.Get(1, 1);


// Use Cell.PutValue() method to input value into the cell.
cell00.PutValue(u"ColumnA");
cell01.PutValue(u"ColumnB");
cell10.PutValue(u"ValueA");
cell11.PutValue(u"ValueB");


// Save workbook to resultFile folder
wkb.Save(u"created_one.ods");

Aspose::Cells::Cleanup();
 

C++ library to create ODS file

There are three options to install “Aspose.Cells for C++” onto your system. Please choose one that resembles your needs and follow the step-by-step instructions:

  1. Install a NuGet Package . See Documentation
  2. Install the library using Include and lib Folders. See Documentation
  3. Install Aspose.Cells for C++ in Linux. See Documentation

System Requirements

Before running the C++ conversion sample source code, make sure that you have the following prerequisites.

  • Microsoft Windows or a compatible OS with C++ Runtime Environment for Windows 32 bit, Windows 64 bit and Linux 64 bit.
  • Add reference to the Aspose.Cells for C++ DLL in your project.

ODS What is ODS File Format?

Files with .ods extension stand for OpenDocument Spreadsheet Document format that are editable by user. Data is stored inside ODF file into rows and columns. It is XML-based format and is one of the several subtypes in the Open Document Formats (ODF) family. The format is specified as part of the ODF 1.2 specifications published and maintained by OASIS. A number of applications on Windows as well as other operating systems can open ODS files for editing and manipulation including Microsoft Excel, NeoOffice and LibreOffice. ODS files can also be converted into other spreadsheet formats as well like XLS, XLSX and others by different applications.

Read More

Other Supported Sheets Generation

You can also create other Microsoft Excel files including few listed below.

XLS (Microsoft Excel Spreadsheet (Legacy))
XLSX (Open XML Workbook)
XLSB (Excel Binary Workbook)
XLSM (Macro-enabled Spreadsheet)
XLT (Excel 97 - 2003 Template)
XLTX (Excel Template)
XLTM (Excel Macro-Enabled Template)
CSV (Comma Separated Values)
TSV (Tab Separated Values)
ODS (OpenDocument Spreadsheet)
PDF (Portable Document Format)
HTML (Hyper Text Markup Language)