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
GitHub Examples
You may easily run the code above and see the feature in action in our GitHub examples:
- GroupDocs.Conversion for .NET examples, plugins, and showcase
- GroupDocs.Conversion for Java examples, plugins, and showcase
- Document Conversion for .NET MVC UI Example
- Document Conversion for .NET App WebForms UI Modern Example
- Document Conversion for Java App Dropwizard UI Modern Example
- Document Conversion for Java Spring UI Example
Free Online Document Converter Apps
Along with full-featured .NET library we provide free Apps and free services for document conversion. In order to see a full potential of GroupDocs.Conversion, you are welcome to convert DOC to PDF, DOC to XLSX, PDF to DOC, PDF to XLSX, PPT to DOC and more with Free Online Document Converter App or get a full advantage of Free Online Document Converter Suite with advanced conversion settings and many more enterprise built-in features.
Please note that more premium features, advanced options and enhanced document management experience is available for signed-in users at conholdate.app for FREE.
If you don’t own an account yet, register it now for free! No credit card is required!