Edit ODS Formats in C#
Native and high performance ODS document editing using server-side Aspose.Cells for .NET APIs, without the use of any software like Microsoft or Adobe PDF.
How to Edit ODS File Using C#
In order to edit ODS file, we’ll use Aspose.Cells for .NET API which is a feature-rich, powerful and easy to use API for C# platform for any editor. Open NuGet package manager, search for Aspose.Cells and install. You may also use the following command from the Package Manager Console.
Command
PM> Install-Package Aspose.Cells
Steps for Editing ODS Files in C#
A basic document editing with Aspose.Cells for .NET APIs can be done with just few lines of code.
- Include the namespace in your class file
- Load your sample file.
- Add and access the new worksheet of the workbook.
- Get the desired cell(s) of the worksheet and put the value in the cell(s).
- Insert PivotTable and set the style
- Use Save method to save the workbook as ODS file.
System Requirements
Our APIs are supported on all major platforms and Operating Systems. Before executing the code below, please make sure that you have the following prerequisites on your system.
- Microsoft Windows or a compatible OS with .NET Framework, .NET Core, Windows Azure, Mono or Xamarin Platforms
- Development environment like Microsoft Visual Studio
- Add reference to the Aspose.Cells for .NET DLL in your project - Install from NuGet using the Download button above
Edit ODS Files - C#
Online ODS Editor Live Demos
Edit ODS documents right now by visiting our Live Demos website . The live demo has the following benefits
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