Important Update
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:
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)
