This custom class is used to provide control over the merging of Excel files and to then output the merged files as a single Excel file.
The CustomMergeExcel class exists within the Presentation/usercustom directory.
The sequence of events to utilize this class are:
- Call doRunCustomMergeExel()
- Perform the logic to create the predefined column reports using the merge Excel template
- Call mergeOutputFiles() to merge the individual files into a single Excel file that is output
- Delete all the temporary result files