SpreadsheetJoinOptions

SpreadsheetJoinOptions class

The spreadsheet join options.

public class SpreadsheetJoinOptions : PageJoinOptions

Constructors

Name Description
SpreadsheetJoinOptions() Initializes a new instance of the SpreadsheetJoinOptions class.
SpreadsheetJoinOptions(FileType) Initializes a new instance of the SpreadsheetJoinOptions class.
SpreadsheetJoinOptions(int[]) Initializes a new instance of the SpreadsheetJoinOptions class.
SpreadsheetJoinOptions(FileType, int[]) Initializes a new instance of the SpreadsheetJoinOptions class.
SpreadsheetJoinOptions(int, int) Initializes a new instance of the SpreadsheetJoinOptions class.
SpreadsheetJoinOptions(FileType, int, int) Initializes a new instance of the SpreadsheetJoinOptions class.
SpreadsheetJoinOptions(int, int, RangeMode) Initializes a new instance of the SpreadsheetJoinOptions class.
SpreadsheetJoinOptions(FileType, int, int, RangeMode) Initializes a new instance of the SpreadsheetJoinOptions class.

Properties

Name Description
Mode { get; set; } The spreadsheet join mode. The default is Worksheets.
Pages { get; } Get page numbers collection.
SheetMatching { get; set; } How the worksheets of the joined spreadsheet are paired with the result worksheets. The default is ByIndex. Has no effect in Worksheets mode.
SkipRows { get; set; } The number of leading rows skipped in every appended worksheet of the joined spreadsheet, for example a header row. Has no effect in Worksheets mode. Must not be negative.
Type { get; } The type of the file to join.

Remarks

When no page numbers are given, the operation applies to every page of the document.

See Also