How to read ODS Open Office Calc spreadsheet document using Bytescout.XLS for .NET

Bytescout.XLS library for .NET

How to read cell values from Open Office Calc spreadsheet document (ODS file extension) using Bytescout.XLS library

This sample provides source code example demonstrating how to use use Bytescout.XLS library to read cell values from Open Office Calc spreadsheet document (.ODS)

Download example source code: bytescoutxls_read_ods_open_office_calc_spreadsheet.zip (8 KB)

Source ODS Open Office Calc spreadsheet document screenshot:

Open Office calc document screenshot

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

namespace HelloWorld
{
class Program
{
static void Main(string[] args)
{
// Create new XLSDocument
XLSDocument document = new XLSDocument("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();
}
}
}

Download example source code: bytescoutxls_read_ods_open_office_calc_spreadsheet.zip (8 KB)

Documentation online: view (separate window)

First steps tutorials:

Advanced Examples: