Export setting: ExcelTemplate: Excel Template

Tag: ExcelTemplate

Apply an Excel template using the format of an existing file.

XML

<SetParam target="ExportToFile" field="ExcelTemplate" value="D:\Automation-export\mugre.xls"/>

If used with any format other than Excel, the ExcelTemplate won't cause an error but it will not initiate.

Example Scripts

This can be done via the ExcelTemplate field/value:

XML

<Export">
	<SetParam target="ExportToFile" field="FilePath" value="D:\Automation-export\exportedACL-ArtBug.xls"/>
	<SetParam target="ExportToFile" field="ExportType" value="Excel"/>
	<SetParam target="ExportToFile" field="ExcelTemplate" value="D:\Automation-export\ReportTemplate.xls"/>
	<SetParam target="ExportToFile" field="OpenFileOnceGenerated" value="true"/>
</Export>

XML

<Export target="GlobalACLProperties">
	<SetParam target="ExportToFile" field="FilePath" value="D:\Automation-export\exported-ArtBug2.xls"/>
	<SetParam target="ExportToFile" field="ExportType" value="Excel"/>
	<SetParam target="ExportToFile" field="ExcelTemplate" value="D:\Automation-export\ReportTemplate.xls"/>
	<SetParam target="ExportToFile" field="OpenFileOnceGenerated" value="true"/>
</Export>