Navigation:  External interfaces > Excel interface > <EXCEL>

vpxPrint considers that an Excel export can be done if an array is encountered within the report.

 

This is specific to 'FOR EACH...' structures. vpxPrint considers dashes successive characters ------- as the start of PROGRESS labels (STREAM-IO mode).

 

You may specify </PROGRESS> to override that

         - if you don't want columns drawing

                 -OR-

         - if values contained in the report could be ambiguous with this logic.

 

The new tag <EXCEL> has been added to make the difference between not desired dashes and PROGRESS arrays.

The EXCEL tag is not needed without </PROGRESS> tag in the report.

 

<EXCEL>

indicates to vpxPrint that the next time that vpxPrint reads a line with dashes ------ it can be exported as an Excel array.

 

</EXCEL>

stops  evaluating dashes as PROGRESS labels.

 

Programming notes :

•<EXCEL> does not export lines if a DISPLAY structure or equivalent is not encountered.

•The sequence </PROGRESS><EXCEL> means :

- no layout is applied to the output (</PROGRESS>)

- if a line containing dashes is encountered, this can be evaluated as a PROGRESS Display. Export lines in Excel.