ExcelFilePaginator Class

Namespace:
GemBox.Spreadsheet
Assembly:
GemBox.Spreadsheet.dll

Provides functionality to paginate the workbook content.

public sealed class ExcelFilePaginator
Public NotInheritable Class ExcelFilePaginator
Inheritance:
System.Object
ExcelFilePaginator

Properties

Pages

Gets the workbook pages.

public ReadOnlyCollection<ExcelFilePage> Pages { get; }
Public ReadOnly Property Pages As ReadOnlyCollection(Of ExcelFilePage)
Property Value
System.Collections.ObjectModel.ReadOnlyCollection<ExcelFilePage>

The workbook pages.

Methods

ConvertToImageSource(ImageSaveOptions)

Converts single page specified in options of this ExcelFilePaginator instance to an System.Windows.Media.ImageSource instance.

public ImageSource ConvertToImageSource(ImageSaveOptions options)
Public Function ConvertToImageSource(options As ImageSaveOptions) As ImageSource
Parameters
options
ImageSaveOptions

The options used when converting a single workbook's page to an image.

Returns
System.Windows.Media.ImageSource

A new System.Windows.Media.ImageSource instance created from a single workbook's page specified in options.

See Also

ConvertToXpsDocument(XpsSaveOptions)

Converts this ExcelFilePaginator instance to an System.Windows.Xps.Packaging.XpsDocument instance.

public XpsDocument ConvertToXpsDocument(XpsSaveOptions options)
Public Function ConvertToXpsDocument(options As XpsSaveOptions) As XpsDocument
Parameters
options
XpsSaveOptions

The options used when converting to XML Paper Specification (XPS) document.

Returns
System.Windows.Xps.Packaging.XpsDocument

A new System.Windows.Xps.Packaging.XpsDocument instance created from this ExcelFilePaginator instance.

See Also

Print()

Prints the paginated workbook to the default printer.

public void Print()
Public Sub Print

Print(String)

Prints the paginated workbook to the specified printer.

public void Print(string printerName)
Public Sub Print(printerName As String)
Parameters
printerName
System.String

Printer name.

Print(String, PrintOptions)

Prints the paginated workbook to the specified printer according to specified options.

public void Print(string printerName, PrintOptions options)
Public Sub Print(printerName As String, options As PrintOptions)
Parameters
printerName
System.String

Printer name.

options
PrintOptions

Print options.

Save(Stream, SaveOptions)

Saves the paginated workbook to the specified stream.

public void Save(Stream stream, SaveOptions options)
Public Sub Save(stream As Stream, options As SaveOptions)
Parameters
stream
System.IO.Stream

The stream in which to save the paginated workbook.

options
SaveOptions

The saving options which can be used to define settings for save operation.

Remarks

Parameter options, currently, must be of type PdfSaveOptions, XpsSaveOptions or ImageSaveOptions.

Save(String)

Saves the paginated workbook to a file with the specified path. Path must include file extension.

public void Save(string path)
Public Sub Save(path As String)
Parameters
path
System.String

The path to which to save the paginated workbook.

Remarks

File extension that is extracted from the path is used to create the appropriate SaveOptions derived class instance that is then passed to the Save(String, SaveOptions) method.

Following file extensions are supported:

  • Portable Document Format: .pdf
  • XML Paper Specification: .xps
  • Image: .bmp, .gif, .jpg, .jpeg, .png, .tif, .tiff, .wdp
Exceptions
System.ArgumentException

If file extension is not specified or not supported. If file extension is not recognized, use Save(String, SaveOptions) method overload instead.

Save(String, SaveOptions)

Saves the paginated workbook to a file with the specified path.

public void Save(string path, SaveOptions options)
Public Sub Save(path As String, options As SaveOptions)
Parameters
path
System.String

The path to which to save the paginated workbook.

options
SaveOptions

The saving options which can be used to define settings for save operation.

Remarks

Parameter options, currently, must be of type PdfSaveOptions, XpsSaveOptions or ImageSaveOptions.

Examples