Import folder structures from Excel

If you use Microsoft Excel to structure automated tests, you can import your tree structure into Tosca Commander.

Requirements

To import your tree structure, your Microsoft Excel sheet must fulfill the following requirements:

• The objects are hierarchically structured in columns from left to right.

• Objects of the same hierarchical level are in the same column.

• The ranking of an element is determined by its relative column position in relation to the element of the previous row.

• A value in a row describes exactly one element within the superior level. There can only be one value per row.

• The structure has fewer than 15 levels.

Perform the import

To perform the import into Tosca Commander, follow the steps below:

1. In Microsoft Excel, copy the rows whose structure you want to transfer to Tosca Commander.

2. In Tosca Commander, right-click any folder and select Create Folder structure.

Tosca Commander imports the Microsoft Excel data and recreates the tree in the folder that you selected.