SaveOptions Class

Namespace:

GemBox.Spreadsheet

Assembly:

GemBox.Spreadsheet.dll

Represents a base class for saving options of various file formats.

• C#
• VB.NET

public abstract class SaveOptions

Public MustInherit Class SaveOptions

Inheritance:

System.Object

SaveOptions

Derived

CsvSaveOptions

FixedWidthSaveOptions

HtmlSaveOptions

ImageSaveOptions

OdsSaveOptions

PdfSaveOptions

XlsbSaveOptions

XlsSaveOptions

XlsxSaveOptions

XpsSaveOptions

Remarks

Following classes inherit from this base class:

• XlsxSaveOptions
• XlsbSaveOptions
• XlsSaveOptions
• OdsSaveOptions
• CsvSaveOptions
• FixedWidthSaveOptions
• HtmlSaveOptions
• PdfSaveOptions
• XpsSaveOptions
• ImageSaveOptions

Properties

ContentType

Gets the content-type for this specific file format as defined in the RFC 2616.

• C#
• VB.NET

public abstract string ContentType { get; }

Public MustOverride ReadOnly Property ContentType As String

Property Value

System.String

The content-type for this specific file format.

See Also

RFC 2616

CsvDefault

Gets the default options for saving to Character Separated Values file format.

• C#
• VB.NET

public static CsvSaveOptions CsvDefault { get; }

Public Shared ReadOnly Property CsvDefault As CsvSaveOptions

Property Value

CsvSaveOptions

Remarks

MS Excel uses ';' as default if current culture uses ',' for decimal separator. GemBox.Spreadsheet always uses ','.

HtmlDefault

Gets the default options for saving to HyperText Markup Language File format.

• C#
• VB.NET

public static HtmlSaveOptions HtmlDefault { get; }

Public Shared ReadOnly Property HtmlDefault As HtmlSaveOptions

Property Value

HtmlSaveOptions

ImageDefault

Gets the default options for saving to image formats.

• C#
• VB.NET

public static ImageSaveOptions ImageDefault { get; }

Public Shared ReadOnly Property ImageDefault As ImageSaveOptions

Property Value

ImageSaveOptions

Limitations

Gets limitations for saving to a file formats.

• C#
• VB.NET

public abstract FileFormatLimitations Limitations { get; }

Public MustOverride ReadOnly Property Limitations As FileFormatLimitations

Property Value

FileFormatLimitations

Remarks

This is the table for all limitations of each format:

	Rows	Columns	Colors	CellStyles
XLSX	1048576	16384	16000000	64000
XLS	65536	256	56	3979
ODS	1048576	16384	16000000	64000
CSV	System.Int32.MaxValue	System.Int32.MaxValue	System.Int32.MaxValue	System.Int32.MaxValue
TXT	System.Int32.MaxValue	System.Int32.MaxValue	System.Int32.MaxValue	System.Int32.MaxValue
HTML	System.Int32.MaxValue	System.Int32.MaxValue	System.Int32.MaxValue	System.Int32.MaxValue
PDF	System.Int32.MaxValue	System.Int32.MaxValue	System.Int32.MaxValue	System.Int32.MaxValue
XPS	System.Int32.MaxValue	System.Int32.MaxValue	System.Int32.MaxValue	System.Int32.MaxValue
IMAGE	System.Int32.MaxValue	System.Int32.MaxValue	System.Int32.MaxValue	System.Int32.MaxValue

OdsDefault

Gets the default options for saving to OpenDocument Spreadsheet file format.

• C#
• VB.NET

public static OdsSaveOptions OdsDefault { get; }

Public Shared ReadOnly Property OdsDefault As OdsSaveOptions

Property Value

OdsSaveOptions

PdfDefault

Gets the default options for saving to Portable Document Format file.

• C#
• VB.NET

public static PdfSaveOptions PdfDefault { get; }

Public Shared ReadOnly Property PdfDefault As PdfSaveOptions

Property Value

PdfSaveOptions

TxtDefault

Gets the default options for saving to Tab delimited file format.

• C#
• VB.NET

public static CsvSaveOptions TxtDefault { get; }

Public Shared ReadOnly Property TxtDefault As CsvSaveOptions

Property Value

CsvSaveOptions

XlsbDefault

Gets the default options for saving to XLSB file format (Microsoft Excel Binary File Format).

• C#
• VB.NET

public static XlsbSaveOptions XlsbDefault { get; }

Public Shared ReadOnly Property XlsbDefault As XlsbSaveOptions

Property Value

XlsbSaveOptions

XlsDefault

Gets the default options for saving to, XLS file format (Microsoft Excel Spreadsheet format; Excel 2003 and prior versions) .

• C#
• VB.NET

public static XlsSaveOptions XlsDefault { get; }

Public Shared ReadOnly Property XlsDefault As XlsSaveOptions

Property Value

XlsSaveOptions

XlsxDefault

Gets the default options for saving to XLSX file format (Microsoft Excel Open XML Spreadsheet; Excel 2007 and later).

• C#
• VB.NET

public static XlsxSaveOptions XlsxDefault { get; }

Public Shared ReadOnly Property XlsxDefault As XlsxSaveOptions

Property Value

XlsxSaveOptions

XpsDefault

Gets the default options for saving to XML Paper Specification file format.

• C#
• VB.NET

public static XpsSaveOptions XpsDefault { get; }

Public Shared ReadOnly Property XpsDefault As XpsSaveOptions

Property Value

XpsSaveOptions

Examples

Convert Excel files to PDF in C# and VB.NET

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

See Also

Save(String)