Navigation:  External interfaces > Excel interface

Excel interface has been added in version 7.3.

 

vpxPrint does not reproduce the complexity of a given report with images, random texts.

 

It formats all data inside a FOR EACH... : DISPLAY... statement and send it to EXCEL.

If different FOR EACH... exist in the report, vpxPrint automatically creates additional sheets.

 

The EXCEL export is reachable from the export window.

 

Note: the Excel button does not appear if vpxPrint does not detect a compatible format in the report.

 

Excel specific tags: although you don't need to write anything to export to Excel, vpxPrint supports specific Excel tags to construct more complex sheets, containing charts or formulas. Have a look at <XLS> tag.

 

vpxPrint considers that an Excel export can be done if an array is encountered. This is specific to 'FOR EACH...' structures. vpxPrint evaluates dashes - - - - - - - as the start of PROGRESS labels. You may specify </PROGRESS> to override this if you don't want columns drawing -OR- if values contained in the report could be ambiguous with this logic.

We have introduced a new tag <EXCEL> to make the difference between not desired dashes and PROGRESS arrays.