Create an Excel worksheet with column definitions

Excel worksheet data must be in the first work sheet of the Excel file. First row must contain column names according to template drawing.

Excel worksheet column definitions has 3 standard column names:

  • TemplateDrawing – This column defines which template drawing (.drw or .dwg) will be used in generation. It is also possible to use multiple template drawings by creating columns with consecutive numbering (TemplateDrawing2...TemplateDrawing50). All template drawings will be merged together after the main template file (TemplateDrawing).

  • DrawingFile – This column defines the name of the generated drawing (.drw or .dwg).

    • Excel worksheet: 4 drawings (dwg) will be generated according to definition.

    ID

    Connector1

    Connector2

    Txt1

    Txt2

    TemplateDrawing

    DrawingFile

    K1

    1

    2

    LOCKS

    CLOSE

    Template1.drw

    CIRCUIT-100.dwg

    K1

    3

    4

    LOCKS

    OPEN

    Template1.drw

    CIRCUIT-101.dwg

    K1

    5

    6

    SPARE

    		  

    Template1.drw

    CIRCUIT-102.dwg

    K2

    1

    2

    AIR

    ON

    Template2.drw

    CIRCUIT-103.dwg

    Corresponding template drawing:

    The DrawingFile column can be left out from the Excel worksheet. In this case, one drawing file will be generated and the file name will be asked from the user.

    Excel worksheet: 1 drawing will be generated according to definition. Drawing has 3 sheets because there is 3 rows in worksheet (template drawing has 1 sheet). Drawing name will be asked when drawing is generated.

    TemplateDrawing

    ID_M

    ID_Q

    Drawing number

    OtherTxt

    MotorTemplate.drw

    MO1

    Q01

    11-01

    Text1

    MotorTemplate.drw

    M02

    Q02

    11-02

    Text2

    MotorTemplate.drw

    M03

    Q03

    11-03

    Text3

    Template drawing can contain either one or several sheets. Generation duplicates sheets according to the number of the rows in the Excel worksheet.

    For example, if MotorTemplate.drw contains 3 sheets, the generated drawing contains 3 rows x 3 sheets = 9 sheets.

  • RowNumber – This numeric column can be used to generate several data rows to one drawing file. If the rownumber value is > 0, will be value replaced from the template drawing which is: $ + column name + [rownumber ] + $, for example: $ID[1]$, $ID[2]$, etc.

    Excel worksheet: 2 drawings (.drw) will be generated according to definition.

    RowNumber

    ID

    Connector1

    Connector2

    Txt1

    Txt2

    TemplateDrawing

    DrawingFile

    1

    K1

    1

    2

    LOCKS

    CLOSE

    Template2.drw

    CIRCUIT-100.drw

    2

    K2

    1

    2

    LOCKS

    OPEN

    Template2.drw

    CIRCUIT-100.drw

    1

    K3

    		 3

    4

    SPARE

    		  

    Template2.drw

    CIRCUIT-101.drw
    2 K4

    3

    		 4

    AIR

    ON

    Template2.drw

    CIRCUIT-101.drw

    Corresponding template drawing:

    RowNumber is defined to column link with brackets, e.g. $ID[1]$ and $ID[2]$.

You can define the other column names freely.