How to Read and Write ODF/ODS Files (OpenDocument Spreadsheets)

JosipK

Rate me:

5.00/5 (120 votes)

28 Jul 2011CPOL6 min read

215.1K

7.5K

165

This article will explain the basics of ODF format, and specifically its implementation in spreadsheet applications (OpenOffice.org Calc and Microsoft Office Excel 2007 SP2). Presented is a demo application which writes/reads tabular data to/from .ods files.

odsreadwrite.zip
- OdsReadWrite
  - OdsReadWrite.sln
  - OdsReadWrite
    - app.config
    - App.xaml
    - App.xaml.cs
    - bin
      - Release
        
        Ionic.Zip.Reduced.dll
        
        OdsReadWrite.exe
    - DelegateCommand.cs
    - Input
      - Input.ods
    - MainWindow.xaml
    - MainWindow.xaml.cs
    - MainWindowModel.cs
    - OdsReaderWriter.cs
    - OdsReadWrite.csproj
    - Output
      - Output.ods
    - Properties
    - References
      - Ionic.Zip.Reduced.dll
    - template.ods

<Application x:Class="OdsReadWrite.App"
             xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
             xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
             StartupUri="MainWindow.xaml"/>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

JosipK

Software Developer (Senior) GemBox Ltd

United Kingdom

Josip Kremenic works as a developer at GemBox Software.
He works on:

GemBox.Spreadsheet - a C# / VB.NET Excel component for reading and/or writing XLS, XLSX, CSV, HTML, PDF, XPS and ODS files.
GemBox.Document - a C# / VB.NET Word component for reading and/or writing DOCX, DOC, HTML, PDF, XPS, RTF and TXT files.
GemBox.Presentation- a C# / VB.NET PowerPoint component for reading and/or writing PPTX, PPT, PDF and XPS files.
GemBox.Email - a C# / VB.NET Email component for composing, receiving and sending MSG, EML and MHTML email messages using IMAP, POP and SMTP.
GemBox.Pdf - a C# / VB.NET Pdf component for for reading and/or writing PDF files.

How to Read and Write ODF/ODS Files (OpenDocument Spreadsheets)

License

Comments and Discussions