Merge and Edit Excels

Merge comparison Excel reports and append user-defined metadata values.

• Merge comparison Excel reports.
  1. From the Comparison/Verification Browser, right-click on a model and select Tools > Merge Excels from the context menu.
  2. Select a directory containing comparison Excel files and the maximum number of files to merge into a single Excel.
  3. Click Merge.
  The existing reports are kept and MergeExcel.xlsm is created.
• Edit existing Excel reports.
  1. From the Comparison/Verification Browser, right-click on a model and select Tools > Edit Excel from the context menu.
  2. Select user-defined metadata values.
  3. Select a file path.
  4. Click Apply to append the metadata to the Excel report.