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);
}

More resources

Examples and Demos

Please find more use-cases and complete C# sources of our backend and frontend examples and try them for free!