<< Click to Display Table of Contents >> Navigation:  How to > Excel > Excel general settings

Setting of header and footer:

<XLS-LEFT-HEADER=left header value>

<XLS-CENTER-HEADER=center header value>

<XLS-RIGHT-HEADER=right header value>

<XLS-LEFT-FOOTER=left footer value>

<XLS-CENTER-FOOTER=center footer value>

<XLS-RIGHT-FOOTER=right footer value>

 

Setting the decimal delimiter:

<XLS-DECIMAL=character>

 

vpxPrint has no information about the decimal format of numbers, they appear as strings in the xpr file.

European users generally use a comma character as decimal separator and a point for the thousands. For other users, point is a decimal separator.

Numbers can have a decimal fraction, or not...

To avoid any error in Excel export, it's safe to define the decimal separator.

European users should use <XLS-DECIMAL=,> is they use -E Progress parameter

 

Setting the date format and delimiter:

<XLS-DELIM=character>

 

sets the value of the date delimiter, if different from the standard Windows setting.
Example: for "01.03.2015", <XLS-DELIM=.> specifies that day, month and year are separated by a dot.

 

Other additional settings are more specific, they can be specified with the <XLS> tag.

The XLS tag allows to interact with Excel. More than one XLS tag can exist in the file to specify different sequences.
It can be used to specify different actions on the excel sheet, add formulas or draw a chart.

 

<XLS> tag has no action on standard vpxPrint report, it just specifies additional actions for Excel export.

The Excel export is available from the export window or with the <EXPORT> tag.

 

Multiple <XLS> tags may exist in the report.