Sub-actions: Excel Template

Tag: ExcelTemplate

The ExcelTemplate function automates the action of exporting Excel templates using the format of an existing file.

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

XML

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

Example Script

This can be done via the ExcelTemplate field/value:

<Export Type="FlagsAndRoles">
	<SetParam target="ExportToFile" field="FilePath" value="D:\Automation-export\exportedACL-ArtBug.xls"/>
	<SetParam target="ExportToFile" field="ExportType" value="Excel19972003"/>
	<SetParam target="ExportToFile" field="ExcelTemplate" value="D:\Automation-export\mugre.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="Excel19972003"/>
	<SetParam target="ExportToFile" field="ExcelTemplate" value="D:\Automation-export\mugre.xls"/>
	<SetParam target="ExportToFile" field="OpenFileOnceGenerated" value="true"/>
</Export>

XML