SaveOptions Class

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

Inheritance Hierarchy

SystemObject
GemBox.SpreadsheetSaveOptions
More...

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

Syntax

Copy

public abstract class SaveOptions

Public MustInherit Class SaveOptions

The SaveOptions type exposes the following members.

Properties

	Name	Description
	ContentType	Gets the content-type for this specific file format as defined in the RFC 2616.
	CsvDefault	Gets the default options for saving to Character Separated Values file format.
	HtmlDefault	Gets the default options for saving to HyperText Markup Language File format.
	ImageDefault	Gets the default options for saving to image formats.
	Limitations	Gets limitations for saving to a file formats.
	OdsDefault	Gets the default options for saving to OpenDocument Spreadsheet file format.
	PdfDefault	Gets the default options for saving to Portable Document Format file.
	XlsDefault	Gets the default options for saving to, XLS file format (Microsoft Excel Spreadsheet format; Excel 2003 and prior versions) .
	XlsxDefault	Gets the default options for saving to XLSX file format (Microsoft Excel Open XML Spreadsheet; Excel 2007 and later).
	XpsDefault	Gets the default options for saving to XML Paper Specification file format.

Top

Remarks

Following classes inherit from this base class:

Examples

Following code demonstrates different ways of saving ExcelFile to specified file format.

Copy

// Saves the spreadsheet to a file with the specified path
ef.Save("Report.xlsx");

using (FileStream stream = new FileStream("Report.pdf", FileMode.Create))
{
    // Saves file to the stream
    ef.Save(stream, SaveOptions.PdfDefault);
}

// Saves the file using specified save options
ef.Save("Report.html", new HtmlSaveOptions
{
    SelectionType = SelectionType.EntireFile
});

' Saves the spreadsheet to a file with the specified path
ef.Save("Report.xlsx")

Using stream As New FileStream("Report.pdf", FileMode.Create)
    ' Saves file to the stream
    ef.Save(stream, SaveOptions.PdfDefault)
End Using

' Saves the file using specified save options
ef.Save("Report.html", New HtmlSaveOptions() With {.SelectionType = SelectionType.EntireFile})

Reference

GemBox.Spreadsheet Namespace

Save Overload

Other Resources

Write Excel file in C# and VB.NET

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

Inheritance Hierarchy

SystemObject
  GemBox.SpreadsheetSaveOptions
    GemBox.SpreadsheetCsvSaveOptions
    GemBox.SpreadsheetFixedWidthSaveOptions
    GemBox.SpreadsheetHtmlSaveOptions
    GemBox.SpreadsheetImageSaveOptions
    GemBox.SpreadsheetOdsSaveOptions
    GemBox.SpreadsheetPdfSaveOptions
    GemBox.SpreadsheetXlsSaveOptions
    GemBox.SpreadsheetXlsxSaveOptions
    GemBox.SpreadsheetXpsSaveOptions