Export setting: ExcelTemplate: Excel Template | Automation

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>