Validate spreadsheet

The following example shows you how to check a document for the problems that make it unusable or non-conforming before you save it. The Validate method returns a list of ValidationError objects, each with the message and the location of the problem in the object model. An empty list means nothing known is wrong.

C# example

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

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

            IList<ValidationError> problems = spreadsheet.Validate();

            if (problems.Count == 0)
            {
                Console.WriteLine("No problems found.");
            }
            else
            {
                foreach (ValidationError problem in problems)
                {
                    Console.WriteLine(problem.Location + ": " + problem.Message);
                }
            }
        }
    }
}

VB example

Imports System
Imports System.Collections.Generic
Imports Independentsoft.Office
Imports Independentsoft.Office.Odf

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

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

        Dim problems As IList(Of ValidationError) = spreadsheet.Validate()

        If problems.Count = 0 Then
            Console.WriteLine("No problems found.")
        Else
            For Each problem As ValidationError In problems
                Console.WriteLine(problem.Location & ": " & problem.Message)
            Next
        End If

    End Sub
End Module

ODF .NET > Tutorial > Validate spreadsheet

Need help? Ask our developers: