API Reference
ExcelWorksheetMergeOptions
Options for merging worksheet data into another worksheet.
Inheritance
- Object
- ExcelWorksheetMergeOptions
Usage
Explore 1 API references to this type
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Accepted by parameters 1
Constructors
public ExcelWorksheetMergeOptions() #Inherited Methods
public virtual 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 Int32? TargetStartRow { get; set; } #1-based target row. When omitted, rows are appended after the target worksheet used range.
public 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 Int32? TargetHeaderRow { get; set; } #1-based row containing target headers when ExcelWorksheetMergeOptions.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 ExcelWorksheetMergeOptions.TargetStartRow.
public Int32 BlankRowsBefore { get; set; } #Blank rows to leave before appended data when ExcelWorksheetMergeOptions.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.