ByteScout Spreadsheet SDK – C# – Read ODS (Open Office Calc) Files

Home
/
Articles
/
ByteScout Spreadsheet SDK – C# – Read ODS (Open Office Calc) Files

printable version:
ByteScout-Spreadsheet-SDK-C-sharp-Read-ODS-(Open-Office-Calc)-Files.pdf

How to read ODS (open office calc) files in C# using ByteScout Spreadsheet SDK

How to read ODS (open office calc) files in C#

Source code documentation samples provide quick and easy way to add a required functionality into your application. ByteScout Spreadsheet SDK can read ODS (open office calc) files. It can be used from C#. ByteScout Spreadsheet SDK is the SDK to create, read, modify and calculate spreadsheets. Formula calculations are supported, import and export to and from JSON, CSV, XML, databases, arrays.

The SDK samples like this one below explain how to quickly make your application do read ODS (open office calc) files in C# with the help of ByteScout Spreadsheet SDK. In your C# project or application you may simply copy & paste the code and then run your app! Detailed tutorials and documentation are available along with installed ByteScout Spreadsheet SDK if you’d like to dive deeper into the topic and the details of the API.

Trial version of ByteScout Spreadsheet SDK can be downloaded for free from our website. It also includes source code samples for C# and other programming languages.

On-demand (REST Web API) version:
Web API (on-demand version)

On-premise offline SDK for Windows:
60 Day Free Trial (on-premise)

Program.cs

      using System;
using System.Collections.Generic;
using System.Text;
using Bytescout.Spreadsheet;

namespace HelloWorld
{
    class Program
    {
        static void Main(string[] args)
        {
            // Create new Spreadsheet
            Spreadsheet document = new Spreadsheet();
	document.LoadFromFile("Hello_world.ods");

            // Get worksheet
            Worksheet worksheet = document.Workbook.Worksheets.ByName("Sheet1");

            // Read cell value
            Console.WriteLine("Cell (0,0) value: {0}", worksheet.Cell(0, 0).ValueAsString);

            // Write message
            Console.Write("Press any key to continue...");

            // Wait user input
            Console.ReadKey();
        }
    }
}