Last Updated: 13 Dec 2018 15:23 by ADMIN
ArgumentException with clarification similar to  "'\u001f', hexadecimal value 0x1F, is an invalid character." is thrown when trying to export document containing characters which are not supported in XML document - such as some control characters like 0x00, 0x1F, 0x1B, etc. Such characters are described in the XML specification here:
Although the escaped strings are not supported (see related 181318), the library could prevent the exception and export the document successfully by skipping such characters.
Workaround: remove such characters before the export. Check the following StackOverflow answer for some ideas on code for replacing the characters:

Last Updated: 27 Nov 2018 11:29 by ADMIN
At this point, CsvWorkbookExporter flushes the data to the underlying stream each time a new data is added. This leads to decreased performance. Ensure the best possible performance by flushing the stream at the end of the content generation.

Last Updated: 21 Jul 2017 11:19 by Robert Madrian
Created by: Peshito
Comments: 3
Category: SpreadStreamProcessing
Type: Feature Request
The UTF8 with BOM encoding should be used to properly preserve the different characters.

Available in R3 2017 Official Release.
Last Updated: 30 Mar 2017 14:21 by ADMIN
When a cell value contains commas or new lines, they are not escaped on export to CSV and single value is exported as multiple values.

Workaround: Escape the value manually. For example, use the following extension method to set string cell values:
internal static class CellExporterExtensions
    public static void SetValue(this ICellExporter cell, string value, SpreadDocumentFormat format)
        if (format == SpreadDocumentFormat.Csv)
            if (value.Contains(","))
                // escape all quotes with double quotes
                value = value.Replace("\"", "\"\"");


            // enclose all values within quotes
            value = string.Format("\"{0}\"", value);


Available in LIB version: 2017.1.403