Excel Plug-in

This plug-in expects a flat xml stream as input and returns a xml style sheet as an OutputStream. The style sheet can be opened using excel. In order to use it a number of properties has to be set in the rpl file.

Contents

Report Plug-in Layout

Layout properties

Required layout properties for the Excel plug-in:
Name Value
plugin-type EXCEL
plugin-class ifs.application.printagentservice.impl.extendedformatter.excelplugin.ExcelPlugin
output-extension xml
flattened-xml:enabled TRUE
flattened-xml:strongtyping TRUE
flattened-xml:base-xpath <Any>
flattened-xml TRUE

Plug-in properties

The plug-in properties are not case sensitive and can be in any order, if they are not included in the rpl file the default values will be used.
Name Type Default value Description
useDisplayNames YES/NO YES Whether or not to use display names as column names for the first row.

Plug-in data

This plug-in does not use the data tag of the report plug-in layout.

Plug-in variables

This plug-in does not use the variable tag of the report plug-in layout.

Example

<?xml version="1.0" encoding="UTF-8"?>
<report-layout>
	<properties>
		<version>0.1</version>
		<layout-type>EXCEL</layout-type> <!--SCRIPT,XSL,XML,EXCEL-->
		<plugin-class>ifs.application.printagentservice.impl.extendedformatter.excelplugin.ExcelPlugin</plugin-class>
		<output-method>FILE</output-method> <!-- BINARY,FILE,E-MAIL-->
		<output-extension>xml</output-extension>
		<default-output-reference>
		  <binary>\\user\ZebraGX4</binary>
		  <file>\\user\TEMPOUT</file>
		  <e-mail>firstname.lastname@something.com</e-mail>
	   	  <e-mail-sender>firstname.lastname@something.com</e-mail-sender>
	   	  <e-mail-cc></e-mail-cc>
	   	  <e-mail-subject>Email Subject</e-mail-subject>
	   	  <e-mail-body>
		    <![CDATA[
			Email Body Content from the RPL
		    ]]> 
	   	  </e-mail-body>
		</default-output-reference>
		<full-xml>TRUE</full-xml>
    		<flattened-xml>
			<enabled>TRUE</enabled>
			<strongtyping>TRUE</strongtyping>
			<base-xpath>MODULE_REP/MODULES/MODULE/LOGICAL_UNITS/LOGICAL_UNIT/DATABASE_OBJECTS/DATABASE_OBJECT</base-xpath>
    		</flattened-xml>
		<report-id>MODULE_REP</report-id>
		<report-title>RPL LAYOUT</report-title>
	</properties>
	<plugin>
		<properties>
			<useDisplayNames>YES</useDisplayNames>
		</properties>
		<data>
			<!-- not used by this plugin -->
		</data>
		<variables>
			<!-- not used by this plugin -->
		</variables>
	</plugin>
</report-layout>