CustomMergeExcel Class

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