Load CSV document with options

GroupDocs.Conversion provides CsvLoadOptions to give you control over how source CSV document will be processed. The following options could be set:

Separator - specifies the delimiter
IsMultiEncoded - if true, means that the document contains several encodings
HasFormula - specifies that if text starts with “=” it should be parsed as a formula
ConvertNumericData - specifies that strings with digits should be parsed as numbers
ConvertDateTimeData - specifies that date/time string should be detected and parsed to DateTime
Encoding - specifies the encoding to be used during load

Control behavior of converting date/time and numeric data

The following code sample shows how to convert csv document and control the way the date/time and numeric data have been processed:

Contracts.Func<LoadOptions> getLoadOptions = () => new CsvLoadOptions
{
    ConvertDateTimeData = true,
    ConvertNumericData = true
};
using (Converter converter = new Converter("sample.csv", getLoadOptions))
{
    PdfConvertOptions options = new PdfConvertOptions();
    converter.Convert("converted.pdf", options);
}

Specify delimiter

The following code sample shows how to convert csv document and specify the delimiter

Contracts.Func<LoadOptions> getLoadOptions = () => new CsvLoadOptions
{
    Separator = ','
};
using (Converter converter = new Converter("sample.csv", getLoadOptions))
{
    PdfConvertOptions options = new PdfConvertOptions();
    converter.Convert("converted.pdf", options);
}

Specify encoding

The following code sample shows how to convert csv document and specify the encoding

Contracts.Func<LoadOptions> getLoadOptions = () => new CsvLoadOptions
{
    Encoding = Encoding.GetEncoding("shift_jis")
};
using (Converter converter = new Converter("sample.csv", getLoadOptions))
{
    PdfConvertOptions options = new PdfConvertOptions();
    converter.Convert("converted.pdf", options);
}

Load CAD document with options Load Email document with options