infra CONVERT allows you to export the contents of a test plan directly into a Microsoft Excel workbook. All you need is an excel template file (“*.XLTX”, “*.XLTM”) formatted as described below and Microsoft Excel on the computer on which the export is performed. Using the template, infra CONVERT creates an Excel file (“*.XLSX”, “*.XLSM”, “*.XLS”) with the test plan parameters you specify.

%ProgramData%/ELIAS GmbH/infra-Convert/ExcelReports

Excel templates can be set up and formatted according to your wishes. You can customize the templates provided or create new templates. Place the templates in the folder named ExcelReports above. When exporting test plans, these templates are available, see Functions > Export > Export test plan > Step 2d.

Important Only one worksheet of infra CONVERT can be filled. The position of the sheet in the workbook is irrelevant, but it must be active respectively visible when the template file is saved.

infra CONVERT writes the inspection characteristics line by line, this means among themselves. Name the first cell in the column to be filled with a value with one of the variables from the table below. How to define names in Excel is described in Microsoft Office Help here: Defining and Using Names in Formulas.

Important Each name can only be assigned once.

* [Note The restriction described in the following no longer applies from programme version 2.5.3. From this version onwards, numerical values are no longer exported as text but as numbers.] Nominal and tolerance values are output as a text string to match the representation in the specification on the drawing. If you want to continue calculating with the numeric values, it may be useful to convert the strings into numbers. You can use the Excel VALUE function for this.