How to read ODS Open Office Calc spreadsheet document using Bytescout Spreadsheet for .NET - ByteScout

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

  • Home
  • /
  • Articles
  • /
  • How to read ODS Open Office Calc spreadsheet document using Bytescout Spreadsheet for .NET

How to read cell values from Open Office Calc spreadsheet document (ODS file extension) using Bytescout Spreadsheet SDK

This sample provides source code example demonstrating how to use use Bytescout Spreadsheet SDK 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.Spreadsheet;

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

Tutorials:

prev
next