Interject Documentation > ReportMerge()
Estimated reading time: 1 minuteFunction Summary
Allows the user to merge multiple Excel reports into one based on jMergePoints . For examples and discussion, view the tutorial.
Function Arguments
| Parameter Name | Description | Default | Optional |
|---|---|---|---|
| FileName | The name of the workbook to connect (either a full path name to the file, or a Report Library Sheet Link Code) | NO | |
| MergeID | A unique ID to identify the jMerge (required to clear tabs) | YES | |
| RemoveTabsOnClear | Indicates whether or not to delete merged tabs upon clearing data | FALSE (TRUE requires a MergeID Value) | YES |
| PullOnOpen | Run a pull on the worksheet after opening | FALSE | YES |
| MergePoints | Provide a range reference to a list of jMergePoint functions. If none is provided, then all jMergePoint functions within the book will be considered | YES | |
| Disabled | Function will not execute on pull if set to true | FALSE | YES |
Function Composition
| Formula | Example | Explanation |
|---|---|---|
| =ReportMerge ( FileName , MergeID , RemoveTabsOnClear , PullOnOpen , MergePoints , Disabled ) | =ReportMerge ('\\\adserver01\shared\DavidBTemp\jMergeTestsTimelook_Dist1.xlsx' ,"Test1" ,TRUE ,FALSE ,D12:D19 , FALSE ) | D12:D19 is the range of cells which contains the jMergePoints. In D:14: =jMergePoint("Trend","before",jTabName(First!E14)) In D:16 =jMergePoint("*","before",jTabName()) |