Possible ways to pair the worksheets of a joined spreadsheet with the result worksheets when rows are joined.
publicenumSpreadsheetSheetMatching
Values
Name
Value
Description
ByIndex
0
The n-th worksheet of the joined spreadsheet is appended to the n-th result worksheet. Worksheets beyond the result worksheet count are added as new worksheets.
FirstSheetOnly
1
Only the first worksheet of the joined spreadsheet is appended, to the first result worksheet.