en:infra-convert:user:exceltemp
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
en:infra-convert:user:exceltemp [2019/05/24 14:49] me |
en:infra-convert:user:exceltemp [2019/10/02 13:18] me |
||
|---|---|---|---|
| Line 13: | Line 13: | ||
| #@IC_HTML@# allows you to export the contents of a test plan directly into a Microsoft Excel workbook. All you need is an excel template file (.XLT) formatted as described below and Microsoft Excel on the computer on which the export is performed. Using the template, #@IC_HTML@# creates an Excel file (.XLSX, more file formats coming soon) with the test plan parameters you specify. | #@IC_HTML@# allows you to export the contents of a test plan directly into a Microsoft Excel workbook. All you need is an excel template file (.XLT) formatted as described below and Microsoft Excel on the computer on which the export is performed. Using the template, #@IC_HTML@# creates an Excel file (.XLSX, more file formats coming soon) with the test plan parameters you specify. | ||
| - | {{ :en:infra-convert:user:interface:excel-export_workflow.png?direct&300 |}} | + | {{ :en:infra-convert:user:interface:excel-export_workflow.png?nolink&300 |}} |
| \\ | \\ | ||
| Line 33: | Line 33: | ||
| 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 > [[en:infra-convert:user:functions:cplanexport#arbeitsablauf|Export test plan]] > Step 2d. | 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 > [[en:infra-convert:user:functions:cplanexport#arbeitsablauf|Export test plan]] > Step 2d. | ||
| + | |||
| + | > **Important** Only one worksheet of #@IC_HTML@# 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. | ||
| #@IC_HTML@# 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: [[https://support.office.com/en-us/article/define-and-use-names-in-formulas-4d0f13ac-53b7-422e-afd2-abd7ff379c64|Defining and Using Names in Formulas]]. | #@IC_HTML@# 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: [[https://support.office.com/en-us/article/define-and-use-names-in-formulas-4d0f13ac-53b7-422e-afd2-abd7ff379c64|Defining and Using Names in Formulas]]. | ||
| + | |||
| + | > **Important** Each name can only be assigned once. | ||
| {{ :en:infra-convert:user:interface:excel-pruefbericht_erstellen.png?direct&800 |}} | {{ :en:infra-convert:user:interface:excel-pruefbericht_erstellen.png?direct&800 |}} | ||
| Line 63: | Line 67: | ||
| ^ DrawingQuadrant | Field division | More > Terms > [[en:infra-convert:user:terms#drawing_sheet|Drawing sheet]] | | ^ DrawingQuadrant | Field division | More > Terms > [[en:infra-convert:user:terms#drawing_sheet|Drawing sheet]] | | ||
| ^ SpecialCategory | Category | More > Terms > [[en:infra-convert:user:terms#category_characteristic|Category (characteristic-)]] | | ^ SpecialCategory | Category | More > Terms > [[en:infra-convert:user:terms#category_characteristic|Category (characteristic-)]] | | ||
| - | ^ SpecialCategoryId | Category ID\\ (Available as of program version 1.3.4.1) | More > [[en:infra-convert:user:terms#Kategorie (Merkmal-)|Kategorie (Merkmal-)]] | | + | ^ SpecialCategoryGuid | Category GUID\\ (Available as of program version 1.3.9.4) | More > [[en:infra-convert:user:terms#Kategorie (Merkmal-)|Kategorie (Merkmal-)]] | |
| ^ Tags | Label/Tag | More > Terms > [[en:infra-convert:user:terms#label|Label]] | | ^ Tags | Label/Tag | More > Terms > [[en:infra-convert:user:terms#label|Label]] | | ||
| ^ DrawingSheet | File name of the drawing sheet including the file ending\\ (Available as of program version 1.3.4.1) | | | ^ DrawingSheet | File name of the drawing sheet including the file ending\\ (Available as of program version 1.3.4.1) | | | ||
en/infra-convert/user/exceltemp.txt · Last modified: 2023/11/17 13:54 by me
Page Tools
