CsvSaveOptions Class

Represents options for saving to Character Separated Values file format.

Inheritance Hierarchy

SystemObject
GemBox.SpreadsheetSaveOptions
GemBox.SpreadsheetCsvSaveOptions

Namespace: GemBox.Spreadsheet
Assembly: GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 45.0.35.1187

Syntax

Copy

public sealed class CsvSaveOptions : SaveOptions

Public NotInheritable Class CsvSaveOptions
	Inherits SaveOptions

The CsvSaveOptions type exposes the following members.

Constructors

	Name	Description
	CsvSaveOptions(Char)	Initializes a new instance of the CsvSaveOptions class.
	CsvSaveOptions(CsvType)	Initializes a new instance of the CsvSaveOptions class.

Top

Properties

	Name	Description
	AlwaysQuoteValues	Gets or sets a value indicating whether values in CSV file will always be quoted. Default value is false.
	ContentType	Gets the content-type for CSV file format: "text/tab-separated-values; charset=" + Encoding.WebName if Type is TabDelimited, otherwise "text/csv; charset=" + Encoding.WebName. (Overrides SaveOptionsContentType.)
	Encoding	Gets or sets the encoding for the CSV file.
	FormatProvider	Gets or sets the format provider for the CSV file.
	Limitations	Gets limitations for saving to CSV file format. (Overrides SaveOptionsLimitations.)
	Separator	Gets or sets character that serves as value delimiter.
	Type	Gets or sets value delimiter type, see CsvType.

Top

Examples

Following code demonstrates how to save ExcelCell.Values to CSV file format. Value (numbers, dates, etc.) will be converted to string using specified culture.

Copy

ef.Save(
    "Report.csv",
    new CsvSaveOptions(CsvType.CommaDelimited)
    {
        FormatProvider = CultureInfo.CurrentCulture
    });

ef.Save(
    "Report.csv",
    New CsvSaveOptions(CsvType.CommaDelimited) With {.FormatProvider = CultureInfo.CurrentCulture})

Reference

GemBox.Spreadsheet Namespace

Other Resources

Create and write Excel file in C# and VB.NET