API Reference
ExcelWorksheetMergeOptions
Options for merging worksheet data into another worksheet.
Inheritance
- Object
- ExcelWorksheetMergeOptions
Usage
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Accepted by parameters
- Method ExcelDocument.JoinWorkSheets
- Method ExcelDocument.JoinWorksheets
- Method ExcelDocument.MergeWorkSheets
- Method ExcelDocument.MergeWorksheets
Constructors
public ExcelWorksheetMergeOptions() #Inherited Methods
public override Boolean Equals(Object obj) #BooleanParameters
- obj Object
Properties
public String SourceRange { get; set; } #Source range to copy. When omitted, the source worksheet used range is copied.
public Nullable<Int32> TargetStartRow { get; set; } #1-based target row. When omitted, rows are appended after the target worksheet used range.
public Nullable<Int32> TargetStartColumn { get; set; } #1-based target column. When omitted, the source range's starting column is used.
public Boolean SourceHasHeader { get; set; } #Indicates that the first source row is a header row.
public Boolean IncludeSourceHeader { get; set; } #Copies the source header row. By default, headers are skipped when appending source rows.
public Boolean MatchColumnsByHeader { get; set; } #Matches source columns to target columns by header text before copying values. Existing positional behavior is used when this is false.
public Nullable<Int32> TargetHeaderRow { get; set; } #1-based row containing target headers when MatchColumnsByHeader is true. When omitted, append operations use the first row of the target used range, and explicit target positions use the row immediately above TargetStartRow.
public Int32 BlankRowsBefore { get; set; } #Blank rows to leave before appended data when TargetStartRow is omitted.
public Boolean OverwriteExistingCells { get; set; } #Allows merge/join operations to overwrite existing target cell contents. When false, merge/join operations throw if a non-empty source cell would replace an existing target cell.