SpreadsheetType5 Enumeration

This enumeration specifies how to compare keys during merge.

Syntax Constants 
Enum SpreadsheetType5
    scMergeReplaceText = 0
    scMergeConcatenateText1 = 1
    scMergeConcatenateText2 = 2
End Enum
  • scMergeReplaceText: Replace text labels in spreadsheet 1 with those in spreadsheet 2.
  • scMergeConcatenateText1: Remove text labels from spreadsheet 1 and insert text labels from spreadsheet 2.
  • scMergeConcatenateText2: Merge text labels from both spreadsheets (with spreadsheet 1 having priority.