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.

import java.io.FileOutputStream;
import java.io.OutputStream;

import com.independentsoft.office.odf.Spreadsheet;

public class Example {

    public static void main(String[] args)
    {
        try
        {
            Spreadsheet spreadsheet = new Spreadsheet("c:\\test\\input.ods");

            String csv = spreadsheet.getCsv();

            try (OutputStream stream = new FileOutputStream("c:\\test\\output.csv"))
            {
                stream.write(csv.getBytes("UTF-8"));
            }

            System.out.println(csv);
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

JODF > Tutorial > Export to CSV

Need help? Ask our developers: