ELIAS GmbH
Produktdokumentationen

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
~~NOTOC~~

<WRAP noprint>

> Benutzerhandbuch #@IC_HTML@# > Excel Report Add-In

</WRAP>

====== Create and integrate your own templates ======

----

All files you need to embed your own templates into the Excel Add-In can be found at:
  %ProgramData%\ELIAS GmbH\ELIASExcelReport

<WRAP noprint>
<WRAP group>
<WRAP column 30%>
//**__Inhalt__**//

 • [[en:infra-convert:add-in:customize#Structure of the Excel templates]]\\ 
 • [[en:infra-convert:add-in:customize#Specific features of our templates]]\\ 
 • [[en:infra-convert:add-in:customize#Integrate your template into Excel]]\\ 
 • [[en:infra-convert:add-in:customize#The template "---"]]

\\ 

</WRAP>
</WRAP>
</WRAP>

===== Structure of the Excel templates =====

The templates delivered with the Excel Add-In can be adjusted to your need. We recommend to make a copy of the existing templates and save them under a new name. How to embed them into the Add-In is described below.

We deliver these templates:

^ Name of the template       ^ Content                                                  ^ 
| ELIAS_EMPB_DE_2012.xltx   | Initial sample test report of VDA, status of 2012, German   | 
| ELIAS_EMPB_EN_2012.xltx   | Initial sample test report of VDA, status of 2012, English  | 
| ELIAS_EMPB_DE_2013.xltx   | Initial sample test report of VDA, status of 2013, German   |
| ELIAS_EMPB_EN_2013.xltx   | Initial sample test report of VDA, status of 2013, English  |
| ELIAS_EMPB_DE_2015.xltx   | Initial sample test report of VDA, status of 2015, German, cover sheet in landscape format  |

Those files are Excel templates which don't use macros.

<WRAP important 750px>**Please note:** To open a template in Excel, use the "File / Open" dialog of Excel. If you open a template by double clicking it in the file explorer Excel won't save it as a template!</WRAP>

These are the sheets used by our templates:

^ Name of sheet EN/DE       ^ Content                                                  ^ 
| Data Sheet / Datenblatt  | Input mask for your data and measurements   | 
| Cover Sheet / Deckblatt  | The cover sheet    | 
| Contents PPF / Inhalt PPF   | Table of contents   |
| Documents / Dokumente  | Reference to other documents  |
| PP1 to PP7   | Product related test results   |

All of our templates contain a data sheet. This sheet should be the only one you have to type into.\\ 
If you create your own template you should copy one of our data sheets. This makes your work a lot easier.

===== Specific features of our templates =====
Our templates use conditional links in this form:
   =IF('Data Sheet'!C1="";"";'Data Sheet'!C1)
This results into the following effect: The cell will only be filled, if the referenced cell has a content. This "trick" eliminates the zeros ("0") in the report sheets.

The data sheets is able to evaluate your measurement data. You don't have to use an infra-CONVERT license to fill out the document. You only have to use an Excel, once the document has been created by the Add-In.

<WRAP alert 750px>Due to the complexity of the data sheet we strongly recommend not to change it! If you add columns to the data sheet you have to adjust the cells which evaluate the measurement data!</WRAP>

===== Integrate your template into Excel =====
You need an Excel template file, if you wish to integrate it into our Report Add-In. This file has to be added into the [[de:infra-convert:add-in:reportlist|ReportList.xml]] file.

This file contains all templates, which can be selected inside the Add-In. The order of the entries decides the list order inside the Report Add-In.

Each entry starts with <Reports> and end with </Reports>. Copy such a block and insert it above the </XMLSchemaReportList> entry to integrate your own template. The fields of the new entry have to be adjusted (see below). <wrap important>Important fields</wrap> are marked. This file is a XML database, so every field starts with a "< >" and ends with a "</ >".

^ Field name       ^ Meaning                                                  ^ 
| Reports   | Every template starts with this entry. The following fields define the functions of the Add-In (see bellow). At the end of the definition block this entry must be closed.  | 
| ID   | The <wrap important>identification number</wrap> of the entry. The identification numbers have to be in sequence. The first entry has to be "0000". If the sequence is broken ("0002" before "0001") the Add-In won't work!   | 
| Name   | The <wrap important>name</wrap> under which this template is listed in the Add-In.   |
| Path | The <wrap important>complete file path</wrap> of the template. The path [CommonApplicationData] is equal to the windows variable %ProgramData%. |
| TableName | The name of the table or work sheet where the data is imported to. |
| FirstRow | The number of the first row to be filled. |
| ColID | The column which will be filled with the internal identification number of infra-CONVERT for the feature. \\ "-1" means: Don't use. |
| ColAttributType | The column which will be filled with the attribute type of the feature.\\ "-1" means: Don't use. |
| ColClass | The column which will be filled with the feature class.\\ "-1" means: Don't use. |
| ColLabel | The column which will be filled with the feature description.\\ "-1" means: Don't use. |
| ColText | The column which will be filled with feature text.\\ "-1" means: Don't use. |
| ColValue | The column which will be filled with the nominal value of the feature.\\ "-1" means: Don't use. |
| ColToleranceHigh | The column which will be filled with the upper tolerance of the feature.\\ "-1" means: Don't use. |
| ColToleranceLow | The column which will be filled with the lower tolerance of the feature.\\ "-1" means: Don't use. |
| ColPassung | The column which will be filled with the fit (e.g. H7) of the feature.\\ "-1" means: Don't use. |
| ColStampText | The column which will be filled with the stamp text of the feature.\\ "-1" means: Don't use. |
| ColGraphicFile | The column which will be filled with the complete path and file name of the graphic file of the feature.\\ "-1" means: Don't use. |
| ColComment | The column which will be filled with the comment of the feature.\\ "-1" means: Don't use. |
| ColToleranceTable | The column which will be filled with the tolerance table of the feature.\\ "-1" means: Don't use. |
| ColDrawingQuadrant | The column which will be filled with the drawing quadrant of the feature.\\ "-1" means: Don't use. |
| ColPositionX | The column which will be filled with X-position of the stamp.\\ "-1" means: Don't use. |
| ColPositionY | The column which will be filled with Y-position of the stamp.\\ "-1" means: Don't use. |
| ColDestinationPositionX | The column which will be filled with the X-position of the stamps target point.\\ "-1" means: Don't use. |
| ColDestinationPositionY | The column which will be filled with the Y-position of the stamps target point.\\ "-1" means: Don't use. |
| ColDiameterStamp | The column which will be filled with the radius of the stamp.\\ "-1" means: Don't use. |
| ColAttributFeatureTypeText | The column which will be filled with feature type as a text.\\ "-1" means: Don't use. |
| ColAttributFeatureType | The column which will be filled with the feature type as a number.\\ "-1" means: Don't use. |
| StartMakro | The name of the macro which should be startet after the import.\\ The entry "" means: Don't start a macro. |
| FormatFileName | The complete file path to the format file for the import. |
| InfraConvertSettingFile | The complete path to the infra-CONVERT settings file. If you start infra-CONVERT from within the Add-In another settings file is used then the standard |

Details for the feature property can be found at [[http://www.elias-gmbh.de/wiki/doku.php?id=en:ic:interface:interface#prf_format|Interfaces]]

===== The template "---" =====
The template "---" will be installed by default. This isn't a real template. It's used to import all data of the inspection plan to the table1 of the Excel worksheet. You can do it also by opening an infra-CONVERT CSV file in Excel.

<WRAP noprint>

----

<WRAP group>
<WRAP col2>

<WRAP rightalign>
**Zurück zu**\\ 
Excel Report Add-in > [[en:infra-convert:add-in:use|Bedienung]]

</WRAP>

**Weiter mit**\\ 
Excel Report Add-in > [[en:infra-convert:add-in:faq|FAQ]]

</WRAP>
</WRAP>

</WRAP>
ELIAS GmbHProduktdokumentationen

User Tools

Site Tools

Page Tools

ELIAS GmbH
Produktdokumentationen
