Export to CSV

The following example shows you how to export the whole document to comma separated values with a single call. The GetCsv method writes every table, each preceded by its name, and quotes the fields that contain a comma, a quotation mark or a line break, as specified by RFC 4180.

C# example

using System;
using System.IO;
using Independentsoft.Office.Odf;

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

            string csv = spreadsheet.GetCsv();

            File.WriteAllText("c:\\test\\output.csv", csv);

            Console.WriteLine(csv);
        }
    }
}

VB example

Imports System
Imports System.IO
Imports Independentsoft.Office.Odf

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

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

        Dim csv As String = spreadsheet.GetCsv()

        File.WriteAllText("c:\test\output.csv", csv)

        Console.WriteLine(csv)

    End Sub
End Module

ODF .NET > Tutorial > Export to CSV

Need help? Ask our developers: