Skip to content

Excel Plug-in

This is an advanced report plug-in that adds report data into Excel sheets, either directly or by adding data to a template excel document.

See also: How to work with excel report templates.

Report Plug-in Layout

Layout properties

Required layout properties for the Excel plug-in:

Name Value
plugin-type EXCEL
plugin-class ifs.application.reportingservices.impl.extendedformatter.excelplugin.ExcelPlugin
output-extension xlsx/xslm
flattened-xml:enabled TRUE
flattened-xml:strongtyping TRUE
flattened-xml:full-xsd-column-set ON/OFF, This value is not mandatory, but it will have a major effect on this plug-in. Read more about it here.
flattened-xml:document-model ON/OFF, This value is not mandatory for Excel layouts. But it will have an impact on the data structure.
If the Layout Template was designed for document model in mind it might only work with the property set to 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
use-display-names YES/NO YES Whether or not to use display names as column names for the first row.
excel-template Text <empty> A reference to a Report Layout Template file name. If left empty, the data will be added to an empty Excel sheet.
If a reference is added the template will be parsed and processed.
include-columns LIST (,) <empty> A list of column names. Only columns in this list will be added to the Excel sheet.
exclude-columns LIST (,) <empty> A list of column names. None of the columns in this list will be added to the Excel sheet.
Can not be used in combination with include-columns.

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>9.0</version>          <layout-type>EXCEL</layout-type> <!--SCRIPT,XSL,XML,EXCEL,SIMPLE EXCEL-->          <plugin-class>ifs.application.reportingservices.impl.extendedformatter.excelplugin.ExcelPlugin</plugin-class>          <output-method>E-MAIL</output-method> <!-- BINARY,FILE,E-MAIL this can be more that one value separated by ; -->          <output-name></output-name> <!-- This will default to "ReportId"_"ResultKey" if left empty. You can add a path as part of the filename. -->          <output-extension>xlsx</output-extension> <!-- The file name and attachment name will be a concatenation of <output-name> and <output-extension>. -->          <default-output-reference>              <e-mail></e-mail> <!-- if left empty, it will use the email adress in the print dialog or if not defined it will use the sender address instead (send to yourself). Make sure each user has his own email adress set correctly. -->             <e-mail-sender></e-mail-sender>             <e-mail-cc></e-mail-cc>             <e-mail-subject>Excel report [#ReportTitle] is ready.</e-mail-subject>             <e-mail-body><![CDATA[Printjob: [#PrintJobId] has finished executing. Excel report attached.]]></e-mail-body>             <file-sender></file-sender> <!-- File Sender name configured in solution manager -->             <binary></binary>          </default-output-reference>          <full-xml>TRUE</full-xml>          <flattened-xml>             <enabled>TRUE</enabled>             <strongtyping>TRUE</strongtyping>             <full-xsd-column-set>OFF</full-xsd-column-set>             <document-model>OFF</document-model>          </flattened-xml>          <report-id>ORDER_QUOTATION_REP,CUSTOMER_AGE_REP</report-id> <!-- For which reports should IFS installer register this layout. -->          <report-title>Excel Layout</report-title> <!-- Title used when installed via IFS Installer -->       </properties>       <plugin>          <properties>             <use-display-names>ON</use-display-names>             <excel-template>[#ReportId]_TEMP.xlsx</excel-template> <!-- This line makes this layout dynamic. Just install the Report Template following the name standard -->             <include-columns></include-columns>             <exclude-columns></exclude-columns>          </properties>       </plugin> </report-layout>