Display cell values

The example shows you how to open spreadsheet and display values of all cells from all tables (sheets).

C# example

using System;
using System.Collections.Generic;
using Independentsoft.Office.Odf;

namespace Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            Spreadsheet spreadsheet = new Spreadsheet("c:\\test\\input.ods");

            IList<Table> sheets = spreadsheet.GetTables();

            foreach (Table sheet in sheets)
            {
                foreach (Row row in sheet.Rows)
                {
                    foreach (Cell cell in row.Cells)
                    {
                        Console.WriteLine(cell.Value);
                    }
                }
            }

            Console.Read();
        }
    }
}

VB example

Imports System
Imports Independentsoft.Office.Odf

Module Module1
    Sub Main(ByVal args() As String)

        Dim spreadsheet As Spreadsheet = New Spreadsheet("c:\test\input.ods")

        Dim sheets As Table() = spreadsheet.GetTables()

        For Each sheet As Table In sheets
            For Each row As Row In sheet.Rows
                For Each cell As Cell In row.Cells
                    Console.WriteLine(cell.Value)
                Next
            Next
        Next

        Console.Read()

    End Sub
End Module

Independentsoft - any library, any programming language

ODF .NET > Tutorial > Display cell values

Need help? Ask our developers: