infra CONVERT
blue DAT • infra DAT
mdm TOOL
Sidebar
en:infra-convert:faq_neu
This is an old revision of the document!
Excel export
What should be considered when dealing with Excel test reports?
You can create your own Excel test report templates, customize the templates installed with the program, or use them directly.
See More > Create and customize Excel templates
The Excel Report Add-In known from the predecessor software infra - CONVERT is no longer used. The Excel export function is now integrated in infra CONVERT.
See Functions > Export > Export test plan > Workflow: Export test plan version
The supplied Excel test report templates provide forms for common approval procedures in German and English. You set the language, release procedure and sample size on the “Input” sheet on the far right. Further usage and customization options can be found in the documentation.
See More > Create and customize Excel templates > Standard templates
Known problems and possible solutions
| Problem | Explanation/Solution |
|---|---|
| No data is entered in the Excel file | If the Excel file is created but not filled with values, this can have the following reasons: No data in the test plan – The test plan version to be exported does not contain any characteristics (or test plan attributes) or all characteristics have been filtered out for export. Check the contents of the test plan version in the project that you want to export. Check whether you have activated filters for the export. See Functions > Export > Export test plan > Workflow: Export test plan version Missing cell names – There are no cells named with valid export variables on the sheet. Either these were not defined or the sheet was not active or not in the foreground when the Excel template was saved. See More > Create and customize Excel templates > Structure |
| The sheet is write-protected | If the export process is interrupted with the message that cells are located on a read-only sheet, check whether write protection is not activated for the sheet to be filled. Open the template file in Excel. You can view the protection status under File > Information > Protect workbook. |
| The file is used by another process | You may be trying to overwrite a file that is open in another application. Check if this is the case or save the file under a different name or in a different directory. |
| Formulas are not calculated (#NAME?) | If the entry “#NAME?” is displayed in some fields in an exported Excel file, editing of the document may be restricted. Some formulas are not calculated in the “Protected view” mode. To do this, disable the protected view. Trusted sources can be set in the Excel Trust Center. Contact your administrator for this. |
| The file is write protected | Security settings may prevent access to the template file. Note that the access permissions apply to the user running infra CONVERT at the moment. In this case, contact your administrator. Alternatively, you can try to save the template file with Excel again (File > Save as) or change the directory for test report templates. The location can be set in the infra CONVERT settings. See Settings > Settings > Export > “Excel test plan” group |
| Fehler in der Microsoft-Office-Interop-Schnittstelle | Sollte der Exportvorgang mit einer Fehlermeldung abgebrochen werden, die auf einen Fehler in der Schnittstelle von »Microsoft.Office.Interop« hinweist, besteht möglicherweise ein Fehler in der Microsoft-Excel- beziehungsweise Office-Installation. Führen Sie eine Office-Reparatur durch. |
en/infra-convert/faq_neu.1659442228.txt.gz · Last modified: 2022/08/02 14:10 by me
