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