<EXCEL>

<< Click to Display Table of Contents >>

Navigation:  EXCEL >

<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 vpxPrint to draw columns

         -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 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.